I have found 4 ways to see the load history in Snowflake: SELECT * from "SNOWFLAKE"."ACCOUNT_USAGE"."COPY_HISTORY" SELECT * FROM "SNOWFLAKE"."INFORMATI...

Can I rely on Snowflake's lazy evaluation for testing and exception throwing? Are CTEs lazily evaluated? Is this documented? (related question: Assertions in Snowflake)

I have a source data which contains the following type of a JSON array: [ [ "source 1", 250 ], [ "other source", 58 ], [ "more stuff", 42 ], ... ] There can be 1..N pairs of string...

I have a column of type TIMESTAMP_NTZ and it contains timestamp that I know are on UTC timezone. Mainly I want to convert to TIMESTAMP_TZ because I have other columns that are TIMESTAMP_TZ and I wa...

I am using Snowflake database and ran this query to find total count, number of distinct records and difference: select (select count(*) from mytable) as total_count, (select count(*) from (se...

If I have a table with an auto-incrementing ID column, I'd like to be able to insert a row into that table, and get the ID of the row I just created. I know that generally, StackOverflow questions ...

What is the difference between the use of LATERAL FLATTEN(...) and TABLE(FLATTEN(...)) in Snowflake? I checked the documentation on FLATTEN, LATERAL and TABLE and cannot make heads or tails of a fu...

I'm trying to create an aggregate UDF, for example something like sum or median. The documentation and examples at https://docs.snowflake.net/manuals/sql-reference/udf-sql.html and https://docs.sn...

I have a dataset were a column in with an ARRAY of OBJECTs like this: ID TAGS 1 {"tags": [{"tag": "a"}, {"tag": "b"}]} 2 {"tags": [{"tag": "c"}, {"tag": "d"}]} I want to extract the tag field of...

I want to pivot a table based on a field which can contain "dynamic" values (not always known beforehand). I can make it work by hard coding the values (which is undesirable): SELECT * FR...

I have a pandas dataframe named "df" that I'm creating with the result of a SQL query against a Netezza database. I'm working in Jupyter notebook. The dataframe has two rows and two of th...

I need to modify type VARCHAR(16777216) to NUMBER in snowflake . ALTER TABLE [TABLE_NAME] ALTER [COLUMN_NAME] set data type NUMBER; returns : SQL compilation error: cannot change column [COLUMN_NAM...

is there any way how to merge 2 objects in snowflake? I found https://docs.snowflake.net/manuals/sql-reference/functions/object_insert.html, but that only sets/updates one key at a time. I want to ...

Is there any way we can connect snowflake with GIT for version control. With the help of that, we can maintain version of our merge statement and any other sql script in GIT.

How to convert pandas dataframe back to snowpark dataframe? pandas_df = snowpark_df.to_pandas() ... ???

Snowflake is not showing in the connections dropdown. I am using MWAA 2.0 and the providers are already in the requirements.txt MWAA uses python 3.7 dont know if this can be a thing Requirements.tx...

I am running an AWS Lambda function that uses one layer with snowflake-connector-python. To create the layer I use: docker run -v <your dev directory>:/lambda -it --rm ubuntu apt-get update a...

I'm trying to get snowsql working locally on my machine but I cannot log into my database because it requires that I authenticate with my google account for SSO. The documentation says to use the -...

We use protocol buffers(protobuf) to define our schemas internally and have translators to translate to various other internal representations such as JSON Schema(Protobuf to JSON schema converter)...

I have a few tables with Text array field to copy from Postgres to Snowflake and ran into a problem. The corresponding field in Snowflake is now defined as array. Some values in the text array fi...

I have a pipe that seems to be set up fine, but it just isn't working. I ran select system$pipe_status('"MY_DB"."MY_SCHEMA".MY_PIPE_NAME'); i'm getting back a growing number of...

I am trying to write a query logic to capture all changes from the source. Merge should compare the keys in source and target and process the data accordingly. Below is an example, how can we achie...

Is it possible to load parquet file directly into a snowflake? If yes - how? Thanks.

I am working on a python script that is designed to process some data, create a table if not exists, and truncate the table before inserting a refreshed dataset. I am using a role that has usage, r...

I am trying to create a lambda function in AWS which connects to a Snowflake database. For this I need the snowflake-connector-python[pandas] package (https://docs.snowflake.com/en/user-guide/pytho...