Kenneth Keith Official Site

bigquery google sheets

Integrate BigQuery Google Sheets Seamlessly

—

by

Kenneth Keith
in

Did you know that Connected Sheets lets users easily access, analyze, and share huge amounts of BigQuery data in Google Sheets1?

Today, combining BigQuery and Google Sheets can greatly improve how you work with data. Companies need to quickly analyze big datasets to make smart choices. Google’s BigQuery is a powerful cloud data warehouse that handles big queries fast and saves space by storing data in a columnar format. With BigQuery and Google Sheets together, you can make data analysis and visualization easier.

Linking BigQuery with Google Sheets lets users work together in real-time with a tool they know well, making things more efficient and insightful1. This guide will show you how to do this integration, improve your data handling, and get the best out of BigQuery and Google Sheets.

Key Takeaways

  • Connected Sheets allows users to work with billions of rows from BigQuery directly in Google Sheets1.
  • The BigQuery Google Sheets connector enables seamless data export and analysis within a familiar interface.
  • Users can collaborate with partners, analysts, and stakeholders in a familiar spreadsheet interface1.
  • Scheduled refreshes for BigQuery data must be carefully managed to avoid context propagation issues1.
  • The integration significantly enhances data workflow optimization.

Understanding BigQuery and Google Sheets

To get the most out of BigQuery and Google Sheets, it’s key to know what each tool does best. They work together to make handling, analyzing, and showing big data easier.

What is BigQuery?

BigQuery is a cloud-based data warehouse by Google Cloud. It’s made to handle huge datasets efficiently. It has a storage layer and a compute layer that work together fast, thanks to Google’s network. This setup lets users manage data well without worrying about resources, thanks to its serverless setup2.

BigQuery is great for fast, SQL-like queries on big datasets. It supports standard SQL queries and more, like joins and geospatial analytics2. It’s also good at handling analytical queries, making data compression and query speed better2. Plus, it can query data from places like Cloud Storage and Google Sheets2. This makes it perfect for businesses needing strong data warehouse solutions.

What is Google Sheets?

Google Sheets is a cloud-based spreadsheet app part of Google Workspace. It lets many users work together on spreadsheets at the same time. This makes it great for teams working on data.

Google Sheets works with BigQuery through connectors and tools like Connected Sheets for G Suite Enterprise users. Even with a limit of 10,000 rows from BigQuery, teams can still manage and analyze data well3. Using BigQuery’s power with Google Sheets’ collaboration features means teams can work on data in real-time.

In summary, BigQuery and Google Sheets are strong tools on their own. BigQuery is great for big data analysis, while Google Sheets is easy to use and good for teamwork. Together, they make a strong combo for handling data well in today’s business world.

Why Integrate BigQuery and Google Sheets?

Combining BigQuery with Google Sheets changes how we work with data. It makes analyzing data easier and lets us create reports and visuals that tell a story. It also means we can work with data even when we’re offline and make changes in different ways, making our work better and our decisions smarter.

Benefits of Data Integration

One big plus of data integration is better data visualization. With BigQuery and Google Sheets, you can pull up to 50,000 rows of data, which is a lot3. This is great for businesses and is available to certain customers3. You can also set up schedules for your data to refresh automatically in Google Sheets, keeping it up-to-date3.

This makes work more efficient and lets teams work together better, thanks to tools like Zapier with over 7,000 integrations4.

Use Cases for Integration

BigQuery and Google Sheets are great for many things, like making business plans or checking how good customer service is. They’re also useful for looking at large datasets to make detailed plans and forecasts. For checking customer service quality, you can pull a lot of data into Google Sheets, up to 10,000 rows3.

For back-end engineering, you can use Google Apps Script to automatically sync data from Google Sheets to BigQuery at different times5. This helps everyone work with the same data, making things more consistent and accurate.

Methods to Integrate BigQuery with Google Sheets

There are two ways to link BigQuery with Google Sheets: manual or automated tools. Each method has its own benefits and suits different needs. The choice depends on the dataset size and how often you need to refresh the data.

Manual Method: Explore with Sheets

The manual way lets users move data from BigQuery to Google Sheets using “Explore with Sheets”. It’s great for small datasets, allowing up to 10 MB of data to be moved6. But, the Connected Sheets function has a limit of 25,000 rows6.

To link BigQuery with Google Sheets manually, you need access to Google Cloud, BigQuery, and a project with billing active in BigQuery7. Connected Sheets also helps users work with billions of rows directly from a spreadsheet, making workflows better7.

Automated Tools and Connectors

For bigger needs, tools like Estuary Flow offer easy solutions for bigquery integration with google sheets. Tools such as Coupler.io can automatically move data from BigQuery to Google Sheets. They work with data from Google Analytics 4, Google Ads, MySQL, and Airtable6. Coupler.io can handle up to 127,072 rows of data6.

API Connector by Mixed Analytics lets users add any API to Google Sheets manually, offering more customization for specific data sources8. Coefficient helps over 314,000 professionals keep data in sync with Google Sheets or Excel, making data management easier8.

Method Benefits Limitations Best For
Manual Integration Direct access through “Explore with Sheets,” suitable for smaller datasets Data export limit of up to 10 MB, up to 25,000 rows Individuals needing quick, small-scale data view
Automated Data Connectors Flexibility, supports multiple sources, can handle large data volumes May require initial setup and configuration Businesses needing real-time data sync, high scalability

Step-by-Step Guide: Manual Integration

Integrating BigQuery with Google Sheets is easy and straightforward. It uses BigQuery’s powerful tools and Google Sheets’ flexibility. This makes it a great way to work with your data.

Accessing Your BigQuery Table

Start by logging into your BigQuery console. Pick your project and go to the dataset with your table. BigQuery can handle huge amounts of data, up to petabytes, making it perfect for businesses9.

Connect Your BigQuery Table to Google Sheets

Use BigQuery’s interface to export data by choosing “Explore with Sheets”. This links BigQuery to Google Sheets, letting you pull data into a spreadsheet. BigQuery supports SQL, JavaScript, and Python for easy data management9. This sets the stage for seeing your data in Google Sheets.

View and Manipulate Your Data

After moving your data to Google Sheets, you can use tools to make pivot tables, charts, or filter the data. BigQuery lets you combine data from different sources for deeper analysis9. This combo with Google Sheets boosts your data visualization and reporting abilities10.

step-by-step integration process

Automate Refresh Schedules

To keep your Google Sheets updated, set up automated refreshes with BigQuery. BigQuery can run scheduled queries, keeping your data fresh9. Tools like Coupler.io can refresh Google Sheets every 15 minutes, which is quicker than native options10.

This step-by-step guide helps you manage your data well. It uses BigQuery’s power and Google Sheets’ ease. Getting to your BigQuery data in Google Sheets can make your business tasks smoother.

Utilizing Automated Data Integration Tools

Managing and analyzing data is getting more complex. That’s why automated data integration tools are key. They make connecting BigQuery and Google Sheets easy and keep data up-to-date in real-time.

Overview of Automated Tools

The automated BigQuery Google Sheets connector is a great tool for handling big data. It combines BigQuery’s power with Google Sheets’ ease of use. This makes analyzing data easier and lets you share huge amounts of data easily11.

Using these tools helps you see and share data with ease7.

Setting Up Tools like Estuary Flow

Estuary Flow is a top choice for automating data moves and keeping data in sync. It’s easy to use and handles lots of data smoothly. Plus, it makes sure data moves without losing anything, so you can focus on analyzing it.

Automating Data Refresh and Sync

Tools like Estuary Flow make sure data is always up-to-date. This helps reduce mistakes and speeds up getting software out there12. They also update data automatically, so you always have the latest info for reports and analysis11.

This keeps everyone working with the latest data, making teamwork smoother7.

bigquery google sheets

Using BigQuery with Google Sheets makes managing data easier and more efficient. It lets businesses use cloud data analysis for better insights. Google Sheets is great for handling data and working together, and when you add Google BigQuery, you get powerful analytics easily13.

Google’s GSuite has over 6 million customers and makes over $1 billion a year. BigQuery is key for many companies now14. This combo is part of a trend towards cloud sharing, making updates fast and keeping data in sync14. BigQuery also lets you query data from outside BigQuery, making analysis more flexible14.

BigQuery supports standard SQL, so data analysts can quickly run complex queries on huge datasets13. Working with Google Sheets, you get a smooth data workflow. Tools like Estuary Flow help stream data from Google Sheets to BigQuery in real-time13. This means data in Google Sheets updates BigQuery fast, keeping data fresh and up-to-date14.

Teams can work together easily on data, which helps build a data-driven culture. This is key for many modern analytics tools. With BigQuery, companies can quickly find important insights in huge datasets, giving them an edge15.

Feature Benefit
Real-time Data Sync Allows immediate updates in BigQuery from Google Sheets
Petabyte-Scale Query Processes large datasets in seconds to minutes
Cloud-Based Collaboration Facilitates teamwork and data sharing
Standard SQL Support Simplifies complex data analysis
Data Streaming Tools Provides real-time data flow between platforms

Advantages of Using Connected Sheets

Connected Sheets makes analyzing, visualizing, and sharing huge amounts of data easy in Google Sheets16. It turns complex data into clear insights with charts and tables, making reports better16.

Streamlined Data Analysis

Connected Sheets makes analyzing data easy. It lets users work with huge amounts of data quickly17. Users can connect to BigQuery and manage over three terabytes of data right from Google Sheets17.

Now, accessing BigQuery data is easy through Connected Sheets16. It also automates data entry and cleans up data, making it more useful17.

Collaboration and Sharing

Connected Sheets makes working together on data easier. Many users can edit the same Google Sheet at once, making work smoother16. It uses Google AI to turn simple questions into useful data insights17. This helps teams work better together, making decisions based on data easier.

Case Studies and Examples

Connected Sheets is used in many ways. In retail, it helps understand customer buying habits, improving business planning16. In finance, it’s used for quick risk checks and keeping an eye on investments, boosting efficiency and strategy16. PwC managed over three terabytes of data with it, showing it can handle a lot of data17.

Use Case Industry Outcome
Retail Analytics Retail Enhanced customer insights and sales reporting
Risk Analysis Financial Services Real-time monitoring and analysis
Data Management Professional Services Efficient handling of vast datasets

Connected Sheets is used in many fields, showing its wide impact. It makes getting to important data easy and helps teams work together better. This is seen in many industries and examples.

Limitations of Manual Integration Methods

Manual methods for combining BigQuery and Google Sheets have big challenges, especially for companies with lots of data. These challenges make managing and analyzing data less efficient.

Data Extraction Limits

One big issue is the limit on how much data you can pull from BigQuery and Google Sheets. Even though tools like Google Connected Sheets can handle millions of rows, older methods like “Explore with Sheets” only go up to 25,000 rows18. This limit can slow down work, especially when dealing with huge datasets that need deep analysis. Also, BigQuery can quickly query billions of rows, but moving such large amounts of data to Google Sheets manually is slow and hard19.

Refresh Frequency Constraints

Manual integrations also have limits on how often they can update. For businesses needing up-to-the-minute data, this is a big problem. While Connected Sheets can update automatically, older methods need more work to stay current, leading to delays and errors18. Companies needing quick and current insights often find these limits a big hurdle.

Advanced Tips for BigQuery to Google Sheets Integration

Improving the link between BigQuery and Google Sheets can boost your data analysis. Using best practices in query design and custom scripts makes the experience smoother.

Optimizing Query Performance

For better query performance, use BigQuery’s distributed computing and parallel processing. This speeds up data analysis and reporting, vital for handling huge datasets20. The BI Engine in BigQuery also speeds up queries, especially for reports in Google Data Studio21. Make sure to use the new BigQuery UI to target the right sheet and range, for quicker data access22.

Utilizing Custom Scripts

Custom scripts make BigQuery and Google Sheets work better together. Google Apps Script helps create custom exports and schedules, automating tasks and improving data handling22. If Google Sheets reaches its 10,000 row limit, custom scripts can help manage the data well20. Many groups, like non-profits with tight budgets and limited tech skills, find custom scripts an easy way to do complex data tasks21.

By using these advanced tips, you can make sure your BigQuery and Google Sheets work together well, giving you better performance and functionality in your projects.

Leveraging BigQuery Export to Google Sheets Scripts

Google Apps Script offers a great way to link BigQuery with Google Sheets. We’ll look into how the BigQuery export to Google Sheets script works. We’ll see the perks it brings for automating data and scheduling tasks.

Introduction to Google Apps Script

Google Apps Script uses Javascript to make Google Apps, like Sheets, more powerful. With Google Apps Script automation, you can send data from many spreadsheets to a database at once23. This is great for keeping datasets current without needing to do it by hand. Apps Script also lets you create or pick BigQuery datasets23.

Creating Custom Export Scripts

Making a custom export script means setting up how data moves from BigQuery to Google Sheets. For example, make sure the BigQuery project ID is in column B of your Google Sheet to upload data correctly23. Coupler.io makes the exporting data to Google Sheets automatic, with five steps that take from 15 seconds to 2 minutes24.

BigQuery export to google sheets script

Custom scripts let you export whole tables or pick certain columns and arrange them in a specific order24. You can also add data to BigQuery tables by choosing TRUE in the “Append?” dropdown in column E of the Google Sheet23.

Scheduling and Automating Scripts

Setting up and automating these scripts is key to keeping data fresh without manual work. Using custom script scheduling, you can make your scripts run at set times. This keeps datasets up-to-date25. Automation cuts down on mistakes and makes data more reliable and accurate.

Coupler.io makes setting up automated data flows between BigQuery and Google Sheets easy, even if you don’t know how to code24. This makes the integration’s benefits available to more people, like financial analysts and program directors who have praised Coupler.io24.

Connecting BigQuery to Google Sheets Using Python

Using Python to link BigQuery with Google Sheets makes data handling easier and more efficient. It lets users set up credentials and access, and run scripts to move data from BigQuery to Google Sheets.

Python Libraries for BigQuery and Sheets

Several key libraries are needed for BigQuery and Google Sheets integration with Python. `pandas`, `gspread`, and `oauth2client` are popular among data analysts for their ease of use26. `google-auth-library-python` helps with authenticating to Google Cloud services, making things simpler27.

Setting Up Credentials and Access

Setting up credentials is vital for automating BigQuery to Google Sheets with Python. This includes enabling APIs, setting up service accounts, and creating keys26. Users must authenticate and enable Drive access through the Google Cloud console or Python28. Having client credentials with Google Drive scope makes accessing and transferring data easier27.

Writing and Running Python Scripts

Python scripts can automate BigQuery data into Google Sheets in a customized way. The `to_gbq` function from `pandas` makes moving data to BigQuery easy26. Users can link external tables to data sources via the Google Cloud console or command-line tools, making queries and saving or exporting data to Google Sheets28. Writing scripts for this process ensures datasets are updated regularly, helping in business intelligence.

Automating these tasks cuts down on manual data entry and checks, making reporting more efficient and accurate26. This method opens up more ways to handle data and ensures quality control when moving data between platforms.

Common Issues and Troubleshooting

Working with BigQuery and Google Sheets can sometimes lead to errors. It’s key to spot and fix problems like slow performance, data sync issues, and integration errors. These issues often stem from access rights, query optimization, and sticking to platform limits and best practices.

Troubleshooting Integration Errors

When you run into BigQuery Google Sheets integration errors, know what to look for. Over 30K results in Pivot tables can lead to query failures29. Also, if your results are over 10MB, you might hit query failures29. Errors like “INVALID_USERID” or “Authentication failure: User Id not found” mean your credentials are wrong for scheduled queries30. Make sure your user IDs and credentials are correct to fix these problems.

Managing Performance Issues

Slow query performance can be a real headache. To fix it, check the Google Cloud Service Health page for any outages and look at the job timeline to see where the query took a long time30. If you get “Query fails due to reaching the execution time limit,” check how long your query took to run before30.

Data Sync Problems and Solutions

Dealing with data sync issues is key for smooth workflows. If scheduled refreshes fail because of revoked OAuth authorization, talk to the schedule owner to fix it29. Also, if you change BigQuery table columns, update your Google Sheets to match29. Transfer failures due to outages usually fix themselves in two hours31. If you run into permission problems, check that the account you’re using has the right roles and data editor permissions31.

Best Practices for Data Integration

In the world of data integration, following best practices is key. It ensures data is reliable and secure. Keeping data accurate and private is crucial for its integrity. Regular checks, strong access controls, and secure connections are vital.

These steps help keep data valuable and safe.

Ensuring Data Accuracy

Using a strict validation process is important for data accuracy. Formats like Avro, Parquet, and ORC make queries faster because they’re in binary32. Also, organizing data with partitioning and clustering makes queries faster by focusing on what’s needed32.

This leads to accurate and fast data. BigQuery can handle huge amounts of data quickly, showing its efficiency in keeping data precise32.

Maintaining Data Security

Keeping data safe is a top priority. Google Cloud’s IAM and encryption like TDE and TLS protect data32. Also, using separate infrastructure and VPC controls helps prevent data leaks and unauthorized access33.

Automating ETL workflows with Cloud Scheduler and Cloud Functions reduces security risks. It makes sure data is transformed and loaded without human error32.

Good data integration needs a focus on both accuracy and security. Following these best practices makes data workflows reliable and keeps data safe.

Conclusion

BigQuery and Google Sheets work together to make advanced data analysis easy for everyday business use. This combo lets you access, see, and share BigQuery data right from Google Sheets16. It makes sure your reports and dashboards are always up-to-date with the latest data16. Plus, you can automate report making for up to 100% of your needs with Google Cloud Workflows and Google Sheets34, boosting efficiency a lot.

There are many ways to connect BigQuery with Google Sheets, from manual to using BigQuery Connected Sheets for easy access to huge amounts of data16. Tools like Google Cloud Workflows help automate these steps, cutting down on manual work and making things more efficient34. This is super useful for teams that rely on data and need quick insights to make smart choices.

Knowing the difference between on-demand and capacity-based pricing in BigQuery helps manage costs and performance better35. To get the best performance, consider factors like data size, shuffling, CPU use, and following SQL best practices35. Whether you’re automating tasks or doing deep analysis, BigQuery and Google Sheets together provide a strong solution for your data needs. This shows the value of combining BigQuery and Google Sheets.

FAQ

What is BigQuery?

BigQuery is a cloud-based data warehouse by Google Cloud. It uses a columnar format for storing data. This makes queries run fast and uses less storage space.

What is Google Sheets?

Google Sheets is a cloud-based spreadsheet tool. It’s great for working together in real-time. Users can easily make, edit, and share spreadsheets.

What are the benefits of integrating BigQuery and Google Sheets?

Combining BigQuery and Google Sheets makes data easier to see and work with. It helps create custom reports and manipulate data. This makes exporting, analyzing, and working together smoother within Google Sheets.

What are some use cases for integrating BigQuery and Google Sheets?

It’s useful for business planning, checking customer service, making sales reports, and keeping data consistent. It’s also great for working together on tasks.

What is the ‘Explore with Sheets’ feature in BigQuery?

‘Explore with Sheets’ lets users work with BigQuery data in Google Sheets. It’s great for making pivot tables and pulling data into Google Sheets.

How do automated tools like Estuary Flow enhance integration?

Tools like Estuary Flow make moving data between BigQuery and Google Sheets easy. They have pre-built connectors and support a lot of data. This helps keep data safe and cuts down on manual work.

What are Connected Sheets?

Connected Sheets is a BigQuery feature that lets users handle big datasets in a spreadsheet-like way. It makes working with large data sets easier and more open.

What limitations exist with manual integration methods like ‘Explore with Sheets’?

Manual methods like ‘Explore with Sheets’ have limits. For example, you can only extract 25,000 rows at a time and refresh data once an hour. This can be a problem for big datasets or when you need updates often.

How can I optimize query performance when integrating BigQuery with Google Sheets?

Improve query performance by making queries better and using custom scripts. This makes data analysis faster and more efficient.

What role does Google Apps Script play in integration?

Google Apps Script helps create custom export scripts and automate tasks. It makes working between BigQuery and Google Sheets better for complex data tasks.

How can Python be used to connect BigQuery with Google Sheets?

Python connects BigQuery with Google Sheets using libraries. It lets you run powerful scripts and automate data transfer. This makes integration more customizable and scalable.

What are common issues encountered during integration, and how can they be resolved?

Issues like slow performance, data mismatches, and integration problems can happen. Fix these by checking access rights, making queries better, and following best practices for data integration.

What are best practices for ensuring data accuracy and security in integration?

For data accuracy and security, do regular audits and set access controls. Use secure connections and follow a strict process to protect data during extraction, transfer, and handling.

Source Links

  1. Using Connected Sheets – https://cloud.google.com/bigquery/docs/connected-sheets
  2. BigQuery overview – https://cloud.google.com/bigquery/docs/introduction
  3. Use data from Google BigQuery with Connected Sheets – https://support.google.com/appsheet/answer/11903794?hl=en
  4. Connect your Google-Bigquery to Google-Sheets integration in 2 minutes | Zapier – https://zapier.com/apps/google-bigquery/integrations/google-sheets
  5. Data Sync Between Google BigQuery and Google Sheet – https://medium.com/@kopalgarg/data-sync-between-google-bigquery-with-google-sheet-badf031b7237
  6. Connect BigQuery to Google Sheets Without Coding | Coupler.io Blog – https://blog.coupler.io/bigquery-google-sheets/
  7. Get started with BigQuery data in Google Sheets – https://support.google.com/docs/answer/9702507?hl=en
  8. How to Connect BigQuery to Google Sheets – https://coefficient.io/bigquery-to-google-sheets
  9. Google BigQuery Tutorial: BigQuery for Beginners Guide – https://www.sprinkledata.com/blogs/bigquery-tutorial
  10. How to Connect Google Sheets to BigQuery | Coupler.io Blog – https://blog.coupler.io/connect-google-sheets-to-bigquery/
  11. How to Connect to Google Sheets and BigQuery: Full Tutorial – https://acuto.io/blog/google-sheets-bigquery/
  12. Continuous data integration in BigQuery – https://cloud.google.com/bigquery/docs/continuous-integration-of-data-in-bigquery
  13. How to Load Data From Google Sheets to BigQuery – https://estuary.dev/google-sheets-to-bigquery/
  14. Google Sheets to BigQuery: a step-by-step guide – Supermetrics – https://supermetrics.com/blog/bigquery-query-google-sheets
  15. Getting data from Google Sheets to BigQuery – https://stackoverflow.com/questions/67049921/getting-data-from-google-sheets-to-bigquery
  16. BigQuery Connected Sheets – https://medium.com/google-cloud/bigquery-connected-sheets-180ddb27163e
  17. Connected Sheets is generally available | Google Workspace Blog – https://workspace.google.com/blog/product-announcements/connected-sheets-is-generally-available
  18. Maximizing Efficiency with Google Connected Sheets – https://skills.ai/blog/maximizing-efficiency-with-google-connected-sheets/
  19. Google BigQuery GitHub Integration: 2 Easy Methods – https://hevodata.com/learn/google-bigquery-github-integration/
  20. How to Connect Google Sheets data in BigQuery – https://windsor.ai/how-to-connect-google-sheets-data-in-bigquery/
  21. Connect BigQuery to Google Sheets – https://towardsdatascience.com/connect-bigquery-to-google-sheets-e3c4f1377659
  22. How to Connect several Google Spreadsheets tabs to BigQuery – https://stackoverflow.com/questions/47506910/how-to-connect-several-google-spreadsheets-tabs-to-bigquery
  23. Apps Script tutorial: Upload to a database (Sheets => BigQuery) – https://techandeco.medium.com/apps-script-tutorial-upload-to-a-database-sheets-bigquery-2fee3724f3ca
  24. BigQuery to Google Sheets Integration | Coupler.io – https://www.coupler.io/google-sheets-integrations/google-big-query-to-google-sheets
  25. Google Sheets AddOn – AppScript & BigQuery Integration via Service Account – https://stackoverflow.com/questions/67036798/google-sheets-addon-appscript-bigquery-integration-via-service-account
  26. How to send data from Google Sheets to BigQuery via Pandas – https://medium.com/codex/how-to-send-data-from-google-sheets-to-bigquery-via-pandas-ff3f3b0552f0
  27. Query data from Google Sheets-based table in BigQuery via API using service account – https://stackoverflow.com/questions/47444573/query-data-from-google-sheets-based-table-in-bigquery-via-api-using-service-acco
  28. Create Google Drive external tables – https://cloud.google.com/bigquery/docs/external-data-drive
  29. Fix problems with BigQuery data in Google Sheets – https://support.google.com/docs/answer/9703001?hl=en
  30. Troubleshoot query issues – https://cloud.google.com/bigquery/docs/troubleshoot-queries
  31. Troubleshoot transfer configurations – https://cloud.google.com/bigquery/docs/transfer-troubleshooting
  32. Enhancing Google BigQuery ETL: 9 Best Practices in 2024 – https://estuary.dev/google-bigquery-etl/
  33. Best practices for multi-tenant workloads on BigQuery – https://cloud.google.com/bigquery/docs/best-practices-for-multi-tenant-workloads-on-bigquery
  34. From BigQuery to Sheets using Workflows from Google Cloud – https://hodo.dev/posts/post-46-gcp-workflows-sheets-automation/
  35. Introduction to optimizing query performance – https://cloud.google.com/bigquery/docs/best-practices-performance-overview