Recent Articles

All JSON Snowflake XML
JSON,

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
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
JSON,
CSV vs JSON vs XML – The Best Comparison Guide

CSV vs JSON vs XML – The Best Comparison Guide 2026

We’ve all been there, going from spec to Wikipedia page to another spec to some other article on the topic trying to pick between CSV, XML, and JSON for the…
Kristijan Berta September 25, 2024
JSON, JSON, Snowflake,

Snowflake vs. Redshift – Support for Handling JSON

ANSI SQL 2016 introduced support for querying JSON data directly from SQL. This is a common use case nowadays. JSON is everywhere in web based applications, IOT, NoSQL databases, and…
Uli Bethke June 22, 2021
JSON, JSON,

Working with JSON in Redshift. Options, limitations, and alternatives

Redshift offers limited support to work with JSON documents. We have three options to load JSON data into Redshift. We can convert JSON to a relational model when loading the…
Uli Bethke April 24, 2019
JSON, JSON,

Converting and analysing Rugby JSON data to Oracle Data Visualization Desktop

Here is another post that will show how you can work with the output from Flexter to analyse your data. In this post we will show you how to convert…
Uli Bethke May 22, 2018