Greg Pavlik questions

Greg Pavlik answers

• Transform Array in Snowflake Table Using Data From Different Table
• Snowflake - how to read metadata from parquet files in S3
• how to retrieve number of rows inserted through Snowflake javascript API?
• What is the equivalent of postgresSQL unnest() in snowflake sql
• How to do an as-of-join in SQL (Snowflake)?
• Filter exact match with sentence/words using regex in Snowflake
• Snowflake conditional code: adding new column(idempotent script)
• Can we pass list or array as parameter to JavaScript procedure in snowflake?
• Checking if a key exists in a Snowflake variant
• Parsing JSON list in Snowflake - converting redshift sql to snowflake sql