Using instantaneous scaling of Snowflake cluster at Sonra

Uli Bethke April 2, 2019

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

Read More

Converting clinical trials XML data to Snowflake and Quicksight with Flexter

Uli Bethke March 22, 2019

In this blog post we will show case Flexter, Sonra’s ETL tool for complex XML/JSON data standards. We will convert a large number of XML documents into a relational data warehouse. The documents contain information about clinical trials. The XML files are publicly available on ClinicalTrials.gov. As of March 2019, 299,015 XML documents are available ...

Read More

Snowflake date and time dimension

Uli Bethke January 28, 2019

Here is a simple SQL script that will generate a date dimension in Snowflake. We are using the built-in GENERATOR and SEQ function. Start date for the dimension is 2017-01-01. WITH CTE_MY_DATE AS ( SELECT DATEADD(HOUR, SEQ4(), '2017-01-01 00:00:00') AS MY_DATE FROM TABLE(GENERATOR(ROWCOUNT=>20000)) ) SELECT TO_DATE(MY_DATE) as date ,TO_TIME(MY_DATE) as time ,TO_TIMESTAMP(MY_DATE) as datetime ,YEAR(MY_DATE) ...

Read More

[Event] Building a realtime cloud data warehouse in 4 simple steps

Uli Bethke January 10, 2019

Building a realtime cloud data warehouse in 4 simple steps Join us for a breakfast session on cloud data warehousing! Learn how to model, load, and discover insights from a real-time cloud data warehouse in 4 simple steps. Step 1: Using bike sharing data we will design a data warehouse data model via the Data ...

Read More
1 3 4 5 6 7 9