Recent Articles

All JSON Snowflake XML
Data Lineage,

BigQuery Data Lineage Guide – Features, API, & Limitations

In this post I dive deep into the BigQuery data lineage feature. For those of you who are not familiar with data lineage here is a quick primer.  Data lineage…
Uli Bethke February 2, 2025
Data Lineage,

Databricks Data Lineage – API, Tables, Unity Catalog

In this blog post, I’m taking the Databricks data lineage feature for a test ride. Let’s see what it can do and where you might need to rely on a…
Uli Bethke January 6, 2025
Data Lineage,

Master Snowflake Data Lineage – Features, Tools & Tips

What is Snowflake data lineage? Imagine you’ve just touched down in a bustling, unfamiliar city you’re eager to explore. You step outside your hotel and realise you have no idea…
Uli Bethke November 27, 2024
Data Lineage,

SQL Visualisation Guide – Query Diagrams, Lineage & ERD

Have you ever inherited the SQL codebase from someone else where it is in a “bit of a mess”? 😁 Where you find nested CTEs (Common Table Expressions), stacked like…
Uli Bethke November 3, 2024
Snowflake,

Iceberg Ahead! All you need to know about Snowflake’s Polaris Catalog

What is the Polaris Catalog? At the Snowflake Summit 2024 Snowflake’s CEO Sridhar Ramaswamy announced the Polaris Catalog during the main keynote speech. The announcement around the Polaris Catalog has…
Uli Bethke June 21, 2024
Snowflake, flexter,

How to Parse & Flatten XML in Snowflake with Examples

In this post we cover every detail of parsing XML in Snowflake including storing, loading, querying, and parsing XML. Very few cloud data platforms have native support for parsing XML.…
Uli Bethke June 3, 2024