Tag Archives: Snowflake

New SQL tool for Analysts on Snowflake: Datameer

Over the years, I have been monitoring the analytics software market with a quite simple requirement: I am (still) looking for a tool to let me generate full data pipelines quickly from a browser with the least amount of code. … Continue reading

Posted in Alteryx, Automation, Productivity, Snowflake, SQL | Tagged , , , | Comments Off on New SQL tool for Analysts on Snowflake: Datameer

How to build a history table with Snowflake and Fivetran

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

Cross Tab and Transpose INDB with Snowflake using Pivot and Unpivot

Data for analytics can be structured in two different ways: Wide or Long. Here is an illustration of the two types of format for the same data set: When would you use one vs. the other? In general, wide models … Continue reading

Posted in Alteryx, Snowflake, SQL | Tagged , , , | 1 Comment

Weird query results on Snowflake

If, when you use Tableau or Alteryx to query a Snowflake Database, you are getting weird $ amounts, not matching what is the database, you are experiencing a known bug in the recent versions of the Snowflake ODBC driver: https://support.snowflake.net/s/article/Regression-in-ODBC-v2-16-4-v-2 … Continue reading

Posted in Alteryx, Snowflake, Tableau | Tagged , | Comments Off on Weird query results on Snowflake

How to Load Data in Bulk to Snowflake with Alteryx

Why a post about Snowflake? What does Alteryx and Tableau have to do with Snowflake? Here is some context: as I was planning to launch my Data Lake consulting business, which is now launched, I was looking for a place … Continue reading

Posted in Alteryx, Performance, Snowflake, SQL, Tableau | Tagged , , , , | 13 Comments