In this video, we will learn how to read data from Google Sheets using Big Query. Big Query 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 Sheets). After the schema is recognized, today's data from Google Sheets is visible in BigQuery. You can then run a query to display all of your daily 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.

#bigquery #gcp #googlecloudplatform