What is data warehouse automation? I have been struggling to find a good article or post that explains data warehouse automation. To address this gap I have decide to write up my own post. I hope it helps. As always, feedback is welcome. Data warehouse automation is not some sort of wizardry. It does not automagically build, model, and load ...
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 container technology. You ...
Redshift offers limited support to work with JSON documents. We have two 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 target table columns. There are ...
Please register for the event on this link. To stay competitive in today’s world is to stay agile by making swift, intelligent, data-driven decisions. Join us at the Dublin stop on our Data for Breakfast tour to see how you can enable your organisation to be data-driven. You’ll leave with a playbook to: Escape the constraints of legacy ...
Snowflake offers some unique features. With instantenous cluster scaling you can scale a cluster up and down in the blink of an eye. Find out in this video how we use instant scaling of Snowflake clusters at Sonra. Please contact us for our Snowflake expert services
