LATERAL_FLATTEN Archives - Cloudyard

Parse API JSON Response to Relational

By Sachin MittalApril 20, 2022

Snowflake Scenario

Snowflake: FLATTEN JSON with OUTER switch

By Sachin MittalFebruary 22, 2022February 22, 2022

Snowflake Admin

Snowflake: SPLIT,SPLIT_PART and FLATTEN

By Sachin MittalAugust 10, 2021August 10, 2021

Snowflake Scenario

Directory Tables, Python UDF and Streams for PDF Processing

Data Quality with Snowflake Data Metric Functions (DMF)

Triggered Tasks in Snowflake

Splitting Large CSV Files in Snowflake Using Snowpark

Data Security with Snowflake: Row Access, Masking, and Projection Policies

Tracking Schema Changes in Iceberg Tables Using Metadata Files

DDL change proc output

Tracking DDL Changes in Snowflake: A Real-World Solution

Unlocking the Power of Snowpark DataFrames with Modin