Recent Articles

All Data Marketplace Flexter FlowHigh JSON Snowflake XML
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
Data Warehouse,

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

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…
Uli Bethke January 10, 2019
Snowflake,

Build a Predictive Model on Snowflake in 1 day with Xpanse AI

Intro “Building a Churn Model is at least 3 months of work”You are the Data Analytics Manager and you have successfully implemented your Snowflake data warehouse. Great news! You deserve…
Uli Bethke January 3, 2019
Oracle,

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,…
Federico Sicilia November 28, 2018
Snowflake,

Comparing Snowflake cloud data warehouse to AWS Athena query service.

In this blog post we look at the commonalities and differences between the Snowflake cloud data warehouse and the AWS Athena query service. AWS Athena is built on top of…
Uli Bethke November 27, 2018
Snowflake,

Sampling in Snowflake. Approximate Query Processing for fast Data Visualisation

Introduction Making decisions can be defined as a process to achieve a desirable result by gathering and comparing all available information.The ideal situation would be to have all the necessary…
Martin Goebbels August 2, 2018