Recent Articles

All JSON Snowflake XML
JSON,

Convert XML to JSON: The Complete Guide with Examples (2026)

XML to JSON conversion is the process of transforming an XML document's hierarchical tag-based structure into JSON's key-value pair format. It looks like the kind of task that should take…
Maciek July 14, 2026
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…
Uli Bethke 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