Snowflake vs. Redshift – Support for Handling JSON

Uli Bethke June 22, 2021

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 when querying APIs. In this document we compare Amazon Redshift and Snowflake features to handle JSON documents. Loading JSON data In this section, we will ...

Read More

Converting Trello JSON to Redshift

Uli Bethke April 26, 2019

In this blog post we will show case Flexter, Sonra’s data warehouse automation solution for complex XML and JSON documents. We will process Trello JSON for this showcase.Flexter is a Spark application written in Scala. For this blog post we will use the managed cloud version of Flexter. Flexter SaaS is built on top of ...

Read More

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

Uli Bethke April 24, 2019

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 data to Redshift (COPY JSON functions). This requires us to pre-create the relational target data model and to manually map the JSON elements to the ...

Read More

Why is concurrency overrated to measure performance of data warehouse platforms?

Uli Bethke January 11, 2018

The difference between making a good and a bad decisions often comes down to the quality of the pre-defined metrics. If the metric is poor so will be the decision. When comparing performance between different technologies such as Google Big Query (based on a distributed file system – Colossus to be precise) and MPP technologies ...

Read More
1 2 3