This post originally published on medium.com
I have been working on Google BigQuery for the past three years and this blog is to share with you the things that I gathered along the way. One of the most important learning has been that there are a lot of ways to write SQL queries on BigQuery but knowing what works best in terms of cost and time efficiency will help everyone write efficient queries.
Before I share 4 effective ways to write efficient queries on BigQuery, let me share why I feel there is a need to consider this-
BigQuery is a serverless, highly-scalable, and cost-effective cloud data warehouse with an in-memory BI Engine and built-in machine learning. BigQuery runs blazing-fast SQL queries on gigabytes to petabytes of data and simplifies joining public or commercial datasets with your data.