Recent Articles

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

Snowflake XML Parsing – Parse, Flatten & Query XML (2026)

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 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