Data Vault Performance & Constraints on Snowflake

Patrick Cuba, the author of "The Data Vault Guru: A Pragmatic Guide on Building a Data Vault", is one of the world's leading thought-leaders on the use of the Data Vault method. He is a prolific blogger and regular contributor to the Data Vault User Group Q&A.

Since joining Snowflake, he has participated in many discussions with Snowflake's global customers on how to architect their Data Vault on Snowflake.

Through experimentation and understanding the nuances of Snowflake, Patrick will share some of the techniques and ideas you could use in your own Data Vault on Snowflake deployment.

As Snowflake has introduced new features, Patrick has developed a workshop (ingestion + consumption), with add-on content looking into some of the specialised features and how they help the ever growing Data Vault Snowflake user base. This presentation will give you a taster!

Customers migrating over from Teradata, Redshift or even starting a new greenfield project have common questions such as:

• How do I take advantage of Snowflake’s MPP?
• Do I use Hash Keys and how will it distribute?
• With no indexes supported on Snowflake, how do I efficiently query content I need especially from very large tables?
• Where should I use Dynamic Tables for Raw Vault?

This talk looks at Snowflake’s unique Data Cloud architecture, and how you can use it to make your Data Vault sing!

PLEASE NOTE: This session is in UK Time: 10:00, EDT 5:00, CEST 11:00