Recent Articles

Snowflake, Snowflake,

Querying hierarchical data in Snowflake

Overview Having the right tools for the job makes the life of a data engineer a lot easier. It is also more fun to work with a platform that has…

Uli Bethke July 4, 2020

Snowflake, Snowflake,

Medvault Success Story – Primary Healthcare Analytics on the Snowflake Cloud Data Platform

Overview: MedVault, an organization offering data management services in primary healthcare, identified the need for a platform which would help their clients to really unlock the value of their data.…

Uli Bethke June 29, 2020

Snowflake, Snowflake,

Snowflake for real time streaming. Change Data Capture with Qlik Replicate

Overview In this two part series on streaming with the Snowflake Data Platform, we use Snowflake for real time analytics.In part one, we use Qlik Replicate to identify changes to…

Uli Bethke June 12, 2020

Snowflake, Data Marketplace, flexter,

Geo and location analytics in action with OpenStreetMap and census data

Geo and location analytics in action with OpenStreetMap and census data In this blog post we integrate and analyse OpenStreetMap, Census, and Geo Data from Ireland. We will use Flexter…

Uli Bethke April 14, 2020

Snowflake,

Snowflake date and time dimension

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.…

Uli Bethke January 28, 2019

Snowflake,

Oracle SQL Developer Data Modeler with Snowflake

Why Oracle SQL Data Modeler Oracle Sql Developer Data Modeler (SDDM) is a free-to-use data modeling tool born to support developers while designing their database, or architecture, at a logical,…

Uli Bethke November 28, 2018