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
11,711
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 ...
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 ...
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
...
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 ...
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?
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 ...
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&...
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 ...
1
vote
1
answer
30
views
Generating a single result set from multiple tables dynamically in Snowflake
I am trying to get a result set with 2 columns from snowflake using dynamic SQL, this is read from the INFORMATION_SCHEMA_TABLES metadata.
I simply want the (TABLE_NAME, PUB_DATE) columns for all ...
0
votes
0
answers
47
views
How to send data from consumer snowflake account to provider snowflake account
I am a new beginner to Snowflake, working on building a Snowflake native app. Forgive me if I mentioned anything wrong. My question is how can I send the data other than logs from the consumer ...
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?
1
vote
1
answer
44
views
Snowflake unsupported subquery type for UDTF
In Snowflake, I'm trying to save a large amount of code size and maintenance by creating a UDTF to show flags for each row v based on presence of rows in x or y meeting some pattern.
The error I get ...
0
votes
0
answers
19
views
How to use downloaded tokenizers in Snowflake UDF
How would you create a snowflake UDF using autotokenizer for example:
I downloaded a tokenizer as follows and then uploaded to Snowflake stage:
from transformers import AutoTokenizer
tokenizer = ...
0
votes
0
answers
48
views
stream select taking too long
I have to final tables, table_1 and table_2, first one with 6.4B rows and second one with 6.3B rows. None of this tables are clustered
On top of this tables, each one have a stream, standard ones, ...