How to read Multiple Google Sheets from Google Spreadsheet in BigQuery | BigQuery External Table
Vložit
- čas přidán 10. 09. 2024
- In this video, we will learn how to read multiple Google Sheets from a Google Spreadsheet in BigQuery. BigQuery is a powerful tool that allows you to access, analyze, visualize, and share billions of rows of data from your spreadsheet with Connected Sheets, the new BigQuery data connector.
To get started, you need to meet all of the following requirements: Access to the Google Cloud Platform, BigQuery access, and a project with billing setup in BigQuery. Once you have met these requirements, you can create a BigQuery table with the data source Google Drive document (URL of Google Spreadsheet). After the schema is recognized, the data from Google Sheets is visible in BigQuery. You can then run a query to display all of your data.
Connected Sheets runs queries on BigQuery on your behalf either when manually requested or on a defined schedule. The results of those queries are saved in your spreadsheet for analysis and sharing. You can also use Connected Sheets to collaborate with partners, analysts, or other stakeholders in a familiar spreadsheet interface.
Script:
=QUERY({Sheet1!A2:D;Sheet2!A2:D},"Select * where Col1 is not null or Col2 is not null ",0)
#bigquery #gcp #googlecloudplatform