Category Archives: Uncategorized

How to build a history table with Snowflake and Fivetran

Posted on 2021-03-30 by Frederic

What I mean by history table is what is commonly called a Slowly Changing Dimension, or SCD table of type 2, which retains efficiently all the previous values I decide to track, for accurate historical reports. Why do we care … Continue reading →

Posted in SFDC, Snowflake, SQL, Uncategorized | Tagged , , | Comments Off on How to build a history table with Snowflake and Fivetran

Snowflake Power Up with Snowsight

Posted on 2020-11-23 by Frederic

One of the many appeals of using Snowflake for me, is the user interface in the browser, which allows not only to perform many admin tasks, but also to poke around data. Yet, that legacy environment, while the envy of … Continue reading →

Posted in Uncategorized | Comments Off on Snowflake Power Up with Snowsight

Easy Fuzzy Match on Names in Tableau with SQL

Posted on 2020-07-14 by Frederic

Finding duplicate entities at scale in large databases using only names coming from free text boxes is always a challenge in Marketing, common in B2C, often ignored in B2B. Let’s take a simple scenario: I have a very long list … Continue reading →

Posted in Marketing, Performance, Snowflake, SQL, Tableau, Uncategorized | Tagged | Comments Off on Easy Fuzzy Match on Names in Tableau with SQL

How to Import SFDC Recursive Hierarchies to Tableau

Posted on 2020-05-07 by Frederic

If you have dealt with hierarchies from Salesforce (SFDC), or from most normalized transactional systems, you have faced some challenges to use those hierarchies in Tableau. Those systems treat hierarchies as a recursive model, storing Parent to Child relationships in … Continue reading →

Posted in Alteryx, Automation, Marketing, Sales, SFDC, SQL, Tableau, Uncategorized | Tagged , | 6 Comments

Snowflake Summit 2019 Debrief

Posted on 2019-06-11 by Frederic

I was very excited at the thought of attending the first edition of the Snowflake customer event In San Francisco last week, and the event did deliver…

Posted in Alteryx, Automation, Performance, Snowflake, SQL, Tableau, Uncategorized | Comments Off on Snowflake Summit 2019 Debrief