Recent Articles

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

The future of ETL and the limitations of data virtualisation and NoETL.

Data has limited value if we don’t transform, integrate, model (either data modelling and building predictive models) or cleanse it. Collecting raw data for no apparent reason or business case…
Uli Bethke October 11, 2018