Recent Articles

All JSON Snowflake XML
JSON,

CSV vs JSON vs XML – The Best Comparison Guide 2024

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…
Maciek 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
JSON, JSON,

Converting FHIR JSON to CSV with Flexter

In this post we will be converting FHIR JSON files to text (CSV). FHIR Fast Healthcare Interoperability Resources (FHIR, pronounced "fire") is a draft standard describing data formats and elements…
Uli Bethke March 16, 2018
Data Pipeline, JSON,

JSON. To ETL or to NoETL? The big data question.

NoETL. The little brother of NoSQL You have probably come across the term NoSQL. It was coined a few years back to describe a class of database systems that can…
Uli Bethke February 19, 2018