CSV
Loading CSV Into Snowflake and Handling Errors in COPY
Load CSV into Snowflake with a file format, a stage and COPY INTO, then read the errors: ON_ERROR, VALIDATION_MODE, VALIDATE and the 64 day skip rule.
7 min read
Topic
Snowflake
Warehouse tactics for the cloud data platform: costs under control, clustering, semi-structured data and time travel.
CSVGuide
Loading CSV Into Cloud Warehouses Without Painful Reloads
How to load CSV into BigQuery, Snowflake and ClickHouse: stage the file, declare the schema, pick an error policy, load once and check the counts afterward.
17 min read
XML
Loading XML Into Snowflake With Native Support and FLATTEN
Snowflake loads XML into VARIANT with a file format of TYPE XML, and XMLGET plus FLATTEN turn it into rows. The statements, the data shape and the limits.
6 min read
XMLGuide
Handling XML in Warehouses and Lakes the Practical Way
How to get XML into Snowflake, BigQuery, Spark, DuckDB and a lake: keep raw files, parse once with a typed schema, store Parquet and reconcile counts.
16 min read
JSON
Flattening Nested JSON With LATERAL FLATTEN in Snowflake
Use FLATTEN in Snowflake to turn VARIANT arrays and objects into rows, chain it for nested levels, keep empty parents with OUTER, and read its output columns.
6 min read
JSON
Querying VARIANT Columns With Colon Syntax in Snowflake
Read JSON stored in a Snowflake VARIANT column with colon and bracket paths, cast the results, and handle JSON null, missing keys and case sensitivity.
7 min read
JSONGuide
JSON in SQL Server Oracle Snowflake and BigQuery Compared
How SQL Server, Oracle, Snowflake and BigQuery store, read, unpack, build and index JSON, side by side, with the null, type and size traps in each.
19 min read
Get new articles by email
We send one email when a new article is published. No spam.