Questions tagged [snowflake-cloud-data-platform]
Snowflake Cloud Data Platform has a multi-cluster, shared architecture that provides a single location for structured and semi-structured data that can be queried using ANSI SQL. Snowflake is a cloud-agnostic platform with very large scale that supports many different workloads: data warehousing and analytics, data lake, data engineering, secure data sharing, data applications, and data science.
snowflake-cloud-data-platform
12,257
questions
0
votes
0
answers
11
views
snowflake cli "snow connection list" command does not show any connection after connection got added successfully
I am trying to setup SNOW CLI in my system . After successful installation I am able to add a connection to config.toml via snow connection add command however on executing snow connection list no ...
- 515
1
vote
0
answers
19
views
Snowflake equivalent for Quotename() in SQL Server?
What would be the equivalent function for quotename() ?
Below is part of a stored procedure:
declare @numcols nvarchar(max)
select @numcols = string_agg(quotename(NAME), ', ') within group (order by ...
- 748k
0
votes
1
answer
138
views
Airflow snowflake connection using private_key_content
I'm trying to connect my airflow dag to my snowflake using private_key_content.
Connection:
{
conn_type: snowflake,
host: <snowflake_host>,
login: <snowflake_user>,
password: ...
- 916
0
votes
0
answers
19
views
Snowpark Procedure Async SQL Execution
I am trying to run a stored procedure in Snowflake written in Snowpark.
Wherein based on a list of tables I am running some SQL for each table.
I am trying to use the async feature to make the sql's ...
3
votes
2
answers
29
views
Rows not getting added to Snowflake table using Python connector
I am trying to create and load a table in Snowflake using Python. The data is in a pandas data frame. Below is the code I'm using. The table gets created, but it has 0 rows and there's no error ...
- 31
0
votes
2
answers
32
views
truncate snowflake division output scale without rounding off
I have a select query having division a/b
The output value is having very large scale .
The output I'm getting is
0.020011991559
I'm expecting the output below. basically 6 digits in scale
0.020011
...
- 25.3k
0
votes
1
answer
20
views
Snowpark- Can load file from sftp and orcale into snowflake table using snowpark?
I am checking for a solution to load file from sftp server into snowflake table using snowpark -snowflake notebook
is there any direct option?
- 58.4k
1
vote
3
answers
1k
views
Tableau connecting to Snowflake using Key-Pair authentication
I'm trying to connect tableau to Snowflake using the Key-pair authentication method. I have generated the keys and associated it with the user. I'm looking for some guidance as how can I configure it ...
- 1
0
votes
1
answer
36
views
Snowflake - Task graph
Task1 has more than one root task a, b. Both the root tasks are suspended and they don't have predecessors. How to enable the root tasks? Can you please give the command?
0
votes
1
answer
17
views
Is there any cost which snowflake charges to provider account to host snowflke native app to snowflake market place?
I am working on creating a snowflake native app using snowpark container services and want to host that app on snowflake marketplace, will snowflake going to charge me anything to host my app on ...
- 1
0
votes
1
answer
611
views
Snowflake streams not working as expected
I am trying use Snowflake streams, but it doesn't work as expected.
Here are the steps I am taking to test it:
Creating a table CREATE OR REPLACE TABLE my_table (id INTEGER, name STRING);
Creating a ...
0
votes
1
answer
39
views
Restructuring actions table into a daily snapshot view
Assuming the default status is always "Released" and given a table that contains history of actions taken:
I'd like to have this to be expanded to a daily snapshot view (last month only) ...
1
vote
0
answers
71
views
Apply large number of decision tree rules to SQL data
I want to apply rules that I've created from modelling on data using a decision tree to unseen data. I've parsed the rules to get a CASE WHEN statement like so:
CASE
WHEN variable_1 = "Value1&...
- 11
0
votes
1
answer
31
views
I'm looking for a SQL statement to copy all details from Product A to Product B
I have Table_P that has columns Product, region, salesperson, production date, end date. (There are other columns, but those fields don't matter to me). Product_X has 6 rows: 6 regions, 3 different ...
- 211
0
votes
1
answer
84
views
250001: Could not connect to Snowflake backend after 2 attempt(s).Aborting
I am trying to connect to snowflake using sql database and snowflake url but I am getting "Could not connect error".
This is the code that I am using:
from langchain import OpenAI, ...
