I'm trying to connect to snowflake via dbt but connections fail with the error below: Using profiles.yml file at /home/myname/.dbt/profiles.yml Using dbt_project.yml file at /mnt/c/Users/Public/lea...

Snowflake allows UNIQUE, PRIMARY KEY, FOREIGN KEY and NOT NULL constraints but I read that it enforces only NOT NULL constraint. Then what is the purpose of other keys and under what circumstances ...

In SnowFlake, would there be any option to execute the sql statements in parallel inside a Stored Procedure. I've a Stored Procedure (shown below), which has 35 sql statements, which run sequential...

I have a task scheduled to run every 15 minutes: CREATE OR REPLACE TASK mytask WAREHOUSE = 'SHARED_WH_MEDIUM' SCHEDULE = '15 MINUTE' STATEMENT_TIMEOUT_IN_SECONDS = 3600, QUERY_TAG = 'KLIPFOLIO...

I am trying to fix an array in a dataset. Currently, I have a data set that has a reference number to multiple different uuids. What I would like to do is flatten this out in Snowflake to make it s...