It's possible to use Snowflake variables to determine a source table as follows: set src='some_table'; select count(*) from $src; However, I'm looking for a way to provide a database name as a v...

The two concepts confused me a lot recently. Snowflake Database more refers to the data service and its website address as below: https://www.snowflake.com/ This is more like a data platform or dat...

I am interested in ways in which users of snowflake database can be insulated from change via the use of schema versioning. I have been investigating the use of connection syntax to define a schema...

I am trying to write an SQL Query to upload JSON data into Snowflake DB Table. The query I have written looks like: insert into xyz_table(id, json_column) values (1, '{ "first_name": "John", "l...

I created a table with a primary key. I would like to alter a primary key. I thought using Alter Table command is the solution, but not successful. ALTER TABLE "tablename" ALTER PRIMARY KEY (col1...

I am using Terraform snowflake plugins. I want to use ${terraform.workspace} variable in terraform scope. terraform { required_providers { snowflake = { source = "chanzuckerberg/snowflake&q...

I have a Snowflake account that uses MFA. Logging in to Snowflake promtps for the MFA and I receive a push notification on my phone. Approving that logs me in. When setting up DBT Cloud it asks for...

Does snowflake support updating/inserting all columns with a syntax like UPDATE * or INSERT * MERGE INTO events USING updates ON events.eventId = updates.eventId WHEN MATCHED THEN UPDATE * ...

For incremental models, the DBT documentation here says: The unique_key should be supplied in your model definition as a string representing a simple column or a list of single quoted column names...

I am trying to insert data from a staging table into the master table. The table has nearly 300 columns, and is a mix of data-typed Varchars, Integers, Decimals, Dates, etc. Snowflake gives the unh...

Let's assume we have a table that contains data as below: CREATE TABLE tab(i INT PRIMARY KEY); INSERT INTO tab(i) VALUES(1),(2),(3); SELECT * FROM tab; Now my goal is to create SQL script that w...

I'm trying to use GREATEST() in Snowflake, but whenever I have null values, I get null instead of the desired result: select greatest(1,2,null); -- null This behavior has confused many, and it be...

GRANT IMPORTED PRIVILEGES ON DATABASE TO ROLE - This provides read access on 'all' objects in the database to a role, instead how to limit read access to subset of objects on database instead of al...

I am trying to use the snowflake connector inside docker container. I want to use the externalbrowser authenticator so that I can make connection using Okta credentials but the connector is failing...

Trying to execute a query like this and getting the numeric value not recognized error. The datatypes for the columns used are Col1 - VARCHAR, Col2 - VARCHAR, Col3 - TIMESTAMP_NTZ(9) This is my ...

I have a table with multiple timestamps, and I want to generate all the timestamps between the max and the min - in intervals of 1 hour with Snowflake. How can I do this?

I've got a table defined in Snowflake as: GLPCT BATCH_KEY NUMBER(38,0) NULL CTACCT VARCHAR(100) NULL CTPAGE NUMBER(38,0) NULL and a file that looks like this: GLPCT.csv CTACCT VARCHAR(100) CTPAGE ...

Is there a way to perform assertions in Snowflake? Basically, I'm trying to do a bit of testing/TDD, and I'd like a mechanism similar to assertions in every other language: If the assertion succ...

The Kafka => Snowflake path is well covered by the Snowflake connector (and other tools). What about moving the data in the other direction? Has anyone used the generic JDBC source Kafka connecto...

I'm working in Snowflake trying to explode rows in a table where each row is currently based on a date range provided by start_date and end_date columns. I need to turn this information into a sing...

The dataframe is huge (7-8 million rows). Tried to_sql with chunksize = 5000 but it never finished. Using, from sqlalchemy import create_engine from snowflake.sqlalchemy import URL df.to_sql(sn...

Given this sample table in Snowflake: CREATE OR REPLACE TABLE vnt (src variant) AS SELECT parse_json(column1) as src FROM values ('{"a": 1,"b": 2,"c": 3}'), ('{"a...

I'm trying to find the snowflake equivalent of generate_series() (the PostgreSQL syntax). SELECT generate_series(timestamp '2017-11-01', CURRENT_DATE, '1 day')

I'm trying to orchestrate Snowflake from SSIS. I'm using an ODBC connection and the execute SQL Task. A truncate table statement works fine and the task completes successfully. Changing this to a ...

I need to unpivot a table using fields specified in an array. I have the following query: select * FROM TEMP_TABLE_NAME T unpivot ( val_col for name_col in ( array_of_fields ) ); The issue i...