Best Practices for Using Tableau with Snowflake

As announced in my last post, since joining Snowflake I’ve been working on a whitepaper that provides best practice guidance for using Tableau with our built-for-the-cloud data warehouse.

Well, I’m pleased to report that it’s done. Or at least, done enough to release. You can download it from here:

http://bit.ly/2Dx7Fyh

I hope you find it useful, and please let me know if you have any feedback or corrections.

About Alan Eldridge

Hi. I'm Alan. By day I manage the APAC sales engineering team for Snowflake Computing. By night, I'm a caped crusader. Or sleeping. Most often it's sleeping.
This entry was posted in Uncategorized. Bookmark the permalink.

2 Responses to Best Practices for Using Tableau with Snowflake

  1. I made a minor update to the whitepaper based on a suggestion from Dan Corey. There’s a new section on accessing semi-structured data elements via RAWSQL functions which provides for a very agile approach. Note that there is currently a bug if you don’t include a field in the RAWSQL function – the simple workaround is to pass in the VARIANT field even though you don’t reference it in the SQL fragment – so you would write:
    RAWSQL_STR(“V:city.name::string”, V)
    instead of just
    RAWSQL_STR(“V:city.name::string”)

    Enjoy!

  2. Another minor update – the document originally suggested that you should keep VARIANT fields to ~8MB for performance reasons. This guidance has changed and is being updated in our online documentation. The document now reads:

    Note that the maximum number of key-value pairs that will be columnarised for a single VARIANT column is 1000. If your semi-structured data has > 1000 key value pairs you may benefit from spreading the data across multiple VARIANT columns. Additionally, each VARIANT entry is limited to a maximum size of 16MB of compressed data.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s