Category Archives: SQL

How to Load Data in Bulk to Snowflake with Alteryx

Posted on 2017-10-31 by Frederic

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

10 Tricks to adopt Redshift In-DB

Posted on 2016-12-01 by Frederic

If you are still manipulating data in Excel, why should you care about In-DB and Redshift? Whether you are accessing your Redshift data through Alteryx or through Tableau, knowing how to prepare your data within Redshift, with In-DB tool in … Continue reading →

Posted in Alteryx, Performance, Redshift, SQL, Tableau | Tagged , , , , , | 1 Comment

How to address INDB Union Error With Alteryx and Redshift

Posted on 2016-08-09 by Frederic

When playing with Alteryx on a Amazon Redshift database with INDB tools, have you ever come up with the impenetrable error: Error: Browse In-DB (36): Error SQLPrepare: [Amazon][RedShift ODBC] (30) Error occurred while trying to execute a query: ERROR: UNION … Continue reading →

Posted in Alteryx, Redshift, SQL | Tagged , , | Comments Off on How to address INDB Union Error With Alteryx and Redshift

How to easily Document your Tableau Reports

Posted on 2015-11-03 by Frederic

Every shiny Tableau dashboard comes, or should come, with less glamorous strings attached: documentation… If you want to share the Tableau love, you ought to document how you drove from a data source to a new indicator, and ultimately to … Continue reading →

Posted in Alteryx, Excel, Qlik, SFDC, SQL, Tableau | Tagged , | 1 Comment

Mask / Anonymize your data with Alteryx

Posted on 2015-07-14 by Frederic

If you handle data, chances are, you have run into this situation where, upon creating a masterpiece visualization, or an innovative report, you need to share it outside your organization for, say: presenting at a conference obtaining vendor technical assistance … Continue reading →

Posted in Alteryx, Excel, Qlik, SQL, Tableau | Tagged | 5 Comments