Below is a Snowflake query that is trying to get the serial number that's associated with each account name (ACCT_NAME), account ID (ACCT_ID), SKU ID (SKU_ID_p2
I have below sample csv data with column delimiter as "|" and row delimiter is "|\n". I am receiving below error. How can I create the File Format? Key|DimType|
I am getting error OSError(28, 'No space left on device') while copying 15 GB zip file into snowflake AWS, via snowsql. Can someone help me to understand this
I am working in Snowflake and have a column pets that I'm trying to put into a url friendly format so they can be concatenated to links within Metabase. Example
I am doing a merge where a string exists in my target table. To this I want to concat a new delta value which is a ; separated string list in my WHEN MATCHED ..
I am currently trying to migrate a T-SQL script to Snowflake. This is the T-SQL script: SELECT * —- a bunch of stuff FROM TABLE_DATE D LEFT JOIN
I have an application publishing messages on a Kafka Topic. I've used Confluent's Snow Sync to synchronize the topic with a Snowflake table so when I publish a
snowflake rank function order by same ROW_MODIFIED_TMST function is generating unique numbers. for example: Table1 Column1 ROW_MODIFIED_TMST
I have a table in snowflake Table1 and I created a stream on Table2. Now I want to check that if there is data in stream based on changes in Table2, then I want
New to snowsql. Installed snowsql and ran the command snowsql -a <account_name> -u <user_name> and that failed with below error: 2022-04-28 18:50:5
I have created a stored procedure in Snowflake to dynamically pivot the table and create a view from JSON data. The query creates a view with 370 columns as I d
I want to show the amount of people in each contract status historically. I have a list of every contract's start date, suspension dates, expiration date, and t
have a json field [ {'id':'1', 'name':'test1', 'address':'123 Main St'}, {'id':'1', 'name':'test2', 'address':'1404 Burke St'} ] This is how the record
I am connecting to Snowflake using python (Below code). As you can see I am trying to get Row Count,Date table was created and altered from Information Schema t
I have a requirement where I need to create a UDF in snowflake but it has complex Select and Insert statements. But as per the documentation, SELECT statement c
I am looking for any connector or any other ways that i can connect and get data from snowflake to IoT Sitewise.
I am trying to get from my query history the pct_table_scan as select query_id , (partitions_scanned / nullif(partitions_total,0)) * 100 as pct_table_scan from
I am writing a Service that obtains data from large sql query in database (over 100,000 records) and streams into an API CSV File. Is there any java library fun
C:\Users\raxz>snowsql -a dr61159.ap-southeast-1.aws -u raxz Password: 250001 (n/a): Could not connect to Snowflake backend after 0 attempt(s).Aborting If the
I am trying to run the Snowflake trial. The file is at s3://snowflake-workshop-lab/citibike-trips Supposed to be CSV but is Parquet. Ideas?