Рет қаралды 1,348
For virtual instructor led classes, please reach out to us at operations@datacouch.io
Do you feel like your BigQuery queries are taking an eternity to execute and are costing you a fortune? We've got you covered!
Discover the latest tips and tricks to help you get the most out of your BigQuery experience. Watch the full meetup session and learn about the small tweaks you can make to improve query performance and make them cost-efficient.
0:00 Intro
4:38 Google BigQuery Overview
7:54 BigQuery Architecture
16:51 How to open BigQuery in GCP
21:12 Optimization #1 : Use LIMIT clause
24:42 LIMIT is a Trap
28:07 Optimization #2 : Select as few columns as possible
32:37 Optimization #3 : Use EXPLORE() instead of COUNT()
36:47 Optimization #4 : Use Approximate Aggregate Functions
40:37 Optimization #5 : Trim your data early & often
48:27 Optimization #6 : Sequence of Where Clauses
52:00 Optimization #7 : Push ORDER BY to the end of query
1:00:22 Optimization #8 : Use LIKE instead of REGEXP_CONTAINS
1:03:42 Optimization #9 : Delay resource intensive operations
1:10:58 Bonus: Tips & Tricks
1:14:21 Common Pitfalls w.r.t. BigQuery
1:16:04 Typical Database query execution order
1:16:57 Performance Tips
1:20:24 Why caching does not work in BigQuery?
Let’s come together in Joining our strong 3700+ 𝐦𝐞𝐦𝐛𝐞𝐫𝐬 community where we impart our knowledge regularly on Data, ML, AI, and many more technologies: www.meetup.com/all-things-data/
𝐒𝐭𝐚𝐲 𝐜𝐨𝐧𝐧𝐞𝐜𝐭𝐞𝐝 𝐰𝐢𝐭𝐡 𝐮𝐬!
𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤: / datacouch
𝐓𝐰𝐢𝐭𝐭𝐞𝐫: / datacouch_io
𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧: / datacouch
𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: / datacouch
𝐌𝐞𝐝𝐢𝐮𝐦: / datacouch
Comment, Like, Share and Subscribe to our KZbin Channel!
#bigquery #event #meetup #ai #ml #gcp #cloud #datacouch #datawarehouse