Working with semi-structured data in Snowflake provides great advantages, specially around the continuous ingestion approach. Let's take a look at a simple way of having a single ingestion endpoint and splitting this data into multiple tables with one single insert while having the data at the ingestion level in a VARIANT data type. This approach … Continue reading Multi-Table inserts with Semi-Structured Inputs in Snowflake
A quick Date Dimension with Snowflake
In most data warehouse implementations, a date dimension is created to standardize dates and make time bucketing easier. In this quick example I will discuss how to create a simple query that can generate a table for a Date Dimension. Creating the Ranges & Session Variables ALTER SESSION SET WEEK_START = 0; SET (START_DATE,END_DATE) = … Continue reading A quick Date Dimension with Snowflake
SQL Insights 