December 2017
Beginner to intermediate
264 pages
5h 38m
English
Content preview from Learning Google BigQuery
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Querying external data sources using BigQuery
BigQuery supports querying and joining of data from external data sources on the Google Cloud Platform. The following are the data sources you can query from BigQuery:
- Google Cloud Storage files
- Google Bigtable database
- Google Drive files
The following demo shows how to query a CSV file in the Google Cloud Storage bucket using the BigQuery engine. The performance of the queries against external data sources is not as good as BigQuery data, and so it should be used with caution. The following are the steps to integrate Google Cloud Storage bucket files for querying:
- Create a table definition file for the file in the Google Cloud Storage bucket
- Link the data source as a table in the BigQuery ...