Recent Articles

Benchmarking Snowflake Native Apps

As a long time user of Snowflake we are impressed with the near unlimited scalability of the Snowflake Data Cloud. We were wondering if the same scalability and performance magic…

Uli Bethke November 20, 2023

Optimal Usage of Snowflake Virtual Warehouses: Breaking Down Parallelism & Concurrency

If you aim to harness the full potential of Snowflake's virtual warehouses, it's crucial to grasp how Snowflake datalake architecture handles concurrency and parallelism. Here's a simplified rundown: 🔍 Basics…

Uli Bethke September 29, 2023

7 guardrails against common mistakes that inflate Snowflake credit usage

Dodge costly pitfalls Snowflake implementation has pioneered dozens of innovations in the data platform space. The long list includes separation of compute and storage, physical workload separation, data sharing, data…

Uli Bethke September 13, 2023

Data lake, Snowflake,

Best Practices for implementing a Data Lake on Snowflake

Data lakes. An introduction Data lakes are a common and useful design pattern in modern data architecture. Contrary to a widespread belief, data lakes have been around for a long…

Uli Bethke April 20, 2022

Snowflake, Snowflake, XML,

Converting Workday XML to Snowflake

Overview In this post we will show you how you can easily convert Workday XML or any other XML to a Snowflake database. We will use Sonra’s Paranoid to mask…

Uli Bethke March 30, 2022

Snowflake, Snowflake,

Date Dimension with Global Holiday Calendar

Overview A date dimension is an essential table in a data model that allows to analyze performance more effectively across different time periods. It should be included in every dimensional…

Uli Bethke March 21, 2022