Recent Articles

All JSON Snowflake XML
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
Data Pipeline,

Data Orchestration Deep Dive Snowflake Tasks. An Airflow replacement? 

What are Snowflake Tasks Snowflake introduced Tasks for scheduling and orchestrating data pipelines and workflows in late 2019. The first release of Tasks only offered the option to schedule SQL…
Uli Bethke May 3, 2024
SQL,

How to Parse XML Data in SQL Server

Are you still using fragile OPENXML and messy SQL to wrestle nested XML into relational tables on SQL Server? You know the drill: It starts as a simple script, but…
Uli Bethke January 25, 2024
SQL Parser,

SQL Parsing for PostgreSQL Table and Column Audit Logging

PostgreSQL, or Postgres, is an open-source object-relational database system known for its reliability, data integrity, and robust features. It offers advanced data types, comprehensive extensibility, and strong community support. Its…
Uli Bethke December 8, 2023
SQL,

Mastering SQL: How to detect and avoid 34+ Common SQL Antipatterns

Overview Are you looking for reasons why your SQL queries are slow or costly. Look no more. This blog post showcases a comprehensive list of 34 SQL antipatterns. Use it…
Uli Bethke December 6, 2023
Snowflake,

Benchmarking Snowflake Native Apps

As a long time user of Snowflake we are impressed with the near unlimited scalability of the Snowflake Data Cloud. We were wondering if the same scalability and performance magic…
Uli Bethke November 20, 2023