BigQuery Best Practices #1 - Structuring Queries
"It just makes the process a little bit easier ..."
We are talking about some Tips & Tricks for your BigQuery SQL Queries. WHERE TRUE is the hidden champion in our daily life, using Aliases leads to an easy life and please use the dot notation in JOIN sections.
Company Website: https://www.datadice.io/
Playlist: https://bit.ly/3oqBt9n
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:30 With vs. Inner Queries
07:55 WHERE TRUE
10:15 SELECT Statement: 1 column per line vs. a group of columns per line
12:55 SELECT Statement: First dimensions then metrics
13:30 Use Aliases for tables and the dot notation
15:40 Rename the column already in the beginning properly
17:40 Add aggregation method in front of the column name
19:02 Conclusion