Exploring BigQuery Best Practices | Google BigQuery | Optimizations | Best Practices скачать в хорошем качестве

Exploring BigQuery Best Practices | Google BigQuery | Optimizations | Best Practices

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: https://www.meetup.com/all-things-data/ 𝐒𝐭𝐚𝐲 𝐜𝐨𝐧𝐧𝐞𝐜𝐭𝐞𝐝 𝐰𝐢𝐭𝐡 𝐮𝐬! 𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤:   / datacouch   𝐓𝐰𝐢𝐭𝐭𝐞𝐫:   / datacouch_io   𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧:   / datacouch   𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦:   / datacouch   𝐌𝐞𝐝𝐢𝐮𝐦:   / datacouch   Comment, Like, Share and Subscribe to our YouTube Channel! #bigquery #event #meetup #ai #ml #gcp #cloud #datacouch #datawarehouse