Recent Articles

All JSON Snowflake XML
JSON,

JSON to SQL & Database – Load, Query, Convert (Guide)

If you work with databases today, you’ve almost certainly come across the JSON data format. It powers everything from API integrations to event streams and user data, and it’s no…
Uli Bethke October 23, 2025
Snowflake,
Flexter XML to SQL converter visual guide for seamless database integration

How to Use the Flexter XML to SQL Database Converter Online

Converting deeply nested XML to database for free, without writing a single line of code. Too good to be true? With Flexter Online, it’s a reality. In this guide, I’ll…
Uli Bethke March 20, 2025
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