Snowflake vs. Redshift – Support for Handling JSON
Uli Bethke
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 MoreConverting Trello JSON to Redshift
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 MoreWorking 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 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 MoreWhy is concurrency overrated to measure performance of data warehouse platforms?
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