"Why are you using GCP?"

Thomas and Alex are talking about the hidden champion in the Google ecosystem: Google Sheets! The main focus is the strong relationship between BigQuery and Google Sheets.

Important questions are, what is Materialization, what are the different integration possibilities and why is your GSheet query sometimes failing (until Goggle fixed it, as it looks like).

Company Website: https://www.datadice.io/

Playlist: https://bit.ly/3tszWTr

Follow us:
Medium (blog posts about Google Data Analytics Release Notes, Data Studio Tips & Tricks, Introductions to Google Cloud Tools and many more): https://bit.ly/3trJPRr

LinkedIn (stay informed about most important company news): https://bit.ly/3qqJKeX

Udemy (Course about Essentials of BigQuery and Data Studio and building an own DWH): https://bit.ly/3tIMIxB

BIG Thanks to Hub633 for the video recording support. https://bit.ly/3I0QXry

Video Content:
00:00 Introduction
01:09 Advantages of GSheets
03:05 BigQuery GSheets Integration
06:39 Define table structure
09:00 Failing Queries with GSheet data
10:15 Tips for handling GSheet data
13:07 Define table structure (text format)
14:30 "Headers row to skip" setting
15:27 Important facts
16:27 Materialize Tables
20:20 Conclusion