Unlocking the Power of Google BigQuery (Cloud Next '19)

preview_player
Показать описание
In this session, senior engineers from BigQuery and The Home Depot will show how to make the most of BigQuery as an Enterprise Data Warehouse. We will explore BigQuery's architecture and cover new features that make BigQuery more powerful than ever. Since there are many challenges in processing and managing master data in an Enterprise Data Warehouse, Home Depot will share how to load and manage Master data in Google's BigQuery environment. This session will help address challenges such as storing the historical changes (slow changing dimensions) to master data.

Watch more:

Speaker(s): Elliott Brossard, Subramanyam Dhurjati

Session ID: DA213
product: Cloud - Data Analytics - BigQuery; fullname: Elliott Brossard, Subramanyam Dhurjati; event: Google Cloud Next 2019;
Рекомендации по теме
Комментарии
Автор

Great content of how HomeDepot migrated to GCP
Challenges for HomeDepot during EDW Migration - 27:45
Change Data Capture - 29:16
AS-IS vs AS-WAS Reporting - 30:08
Versioning - Stacking Approach - Process Diag - 31:49
Stacking Approach - Pros & Cons - 35:12
Versioning - Effective Begin/End Dates & Merge Statements - 36:29

iamshreymehta