enter image description here

enter image description here

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.