Data Warehousing - Which of the Many Cloud Products is the Right One for You

Explore the landscape of modern cloud-based data warehousing solutions in this 53-minute conference talk from PASS Data Community Summit. Delve into the evolving world of data storage and analysis, focusing on new products like Snowflake and Databricks. Learn how to determine the best fit for your environment by examining various aspects such as size, architecture, and performance tuning. Cover topics including Azure SQL Pool, Azure Synapse Analytics, Data Lake Gen 2, HDInsight, Cosmos DB, and Snowflake AWS. Gain insights into batch and streaming processes, data skipping techniques, and the differences between free, standard, and premium versions of Databricks. Equip yourself with the knowledge to make informed decisions about which cloud product best suits your data warehousing needs.

Intro
Overview
Modern Data Warehousing
Size
Architecture
Virtual Machines
SQLDB
Azure SQL Pool
Azure Synapse Analytics
Data Lake Gen 2
Creating an Azure Data Lake
HDInsight
Cosmos DB
Snowflake
Blob Storage
Snowflake AWS
Databricks Delta Lake
Batch and Streaming
Performance Tuning
Data Data Skipping
Databricks
Free version
Standard vs Premium
Summary