Recent Articles

All JSON Snowflake XML
Data Pipeline,

Databricks JSON Guide – Read, Parse, Query & Flatten Data

JSON and Databricks should work smoothly together. They don’t. Yes, Databricks can parse simple JSON files. It can also partially infer their schemas and process them in large chunks. But…
Uli Bethke February 23, 2026
Data Pipeline,

How to Store & Load JSON in Snowflake (File Format Guide)

If you’re working with data today, your pipelines are almost certainly pumping JSON. From API payloads to IoT event streams and microservice logs, JSON is the lingua franca of modern…
Uli Bethke November 26, 2025
Data Pipeline,

How to Use the Flexter Online to Convert Your JSON to CSV and TSV

In this guide, I’ll walk you through Flexter Online: a free JSON to CSV/TSV converter that delivers professional-grade data transformation directly in your browser. Keep reading if you are looking…
Uli Bethke September 16, 2025
Data Pipeline,

How to Use the Flexter Online JSON to Snowflake Converter

Convert deeply nested JSON to a Snowflake, completely free and without writing a single line of code. Sounds too good to be true? With Flexter Online, it isn’t. In this…
Uli Bethke September 16, 2025
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
Data Pipeline,

To hell and back with ETL. The unstoppable rise of data warehouse automation.

A brief history of ETL The rise of ETL and the rise of the data warehouse are tightly coupled. It’s like the chicken and the egg. There would be no…
Uli Bethke May 22, 2020