The command LIST returns a table-like object (Snowflake docs). Thus I’m wondering whether it is possible to write a query on top of this output:

Created 4 tables in both SQL Server and Snowflake.
Inserted these values.

Can someone please help me to debug why the following script cannot run in snowflake? It said it has syntax error inside. Thanks

I have this code in SQL Server, and I want to convert it Snowflake supported code. Issue is in update part. Create procedure part can be done.

I have this code in SQL Server, and I want to convert it Snowflake supported code. Issue is in update part. Create procedure part can be done.

Having this code in mssql i want to make it a snowflake supported code. Issue is in update part. Create procedure part can be done.

in the database (Snowflake) I have a record that is over 20 characters long.

i have two tables. i’m trying to construct a case statement that flags if the values in table 1 are not in the values in table 2.

need one small help with recursive data retrieval using snowflake.
Assume we have a table with below structure

I am looking to build an idea of how many unique visitors who have logged in to my site have had repeat visits over the last year