BigQuery external tables
BigQuery is a fully managed analytics data warehousing solution on Google Cloud. One feature of BigQuery is the ability to query data from external sources, including Bigtable. At the time of writing, this feature is currently in beta, and only available in a select few regions and zones. Bigtable tables can be queried from BigQuery in one of two ways: as permanent external tables or as temporary external tables. Permanent external tables provide better support for table definitions and access controls.
This can be a great approach to finding some middle ground between the high write capabilities of Bigtable and the fully expressive query functionalities of BigQuery, but note that queries will be less performant than ...
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,
and much more.
Read now
Unlock full access