This document outlines the functionality and characteristics of the BigQuery Reader node, which enables automated data retrieval from Google BigQuery.
my-gcp-project
my_dataset
my_table
SELECT * FROM my_dataset.my_table
Each selected column in your query becomes an output containing a list of values from that column.
The BigQuery Reader node executes SQL queries against Google BigQuery tables.
Key features include:
The BigQuery Reader node is particularly valuable in scenarios requiring data extraction from BigQuery. Common use cases include:
Some specific examples:
To query recent sales data:
If you experience frequent reauthentication requests:
In summary, the BigQuery Reader node provides powerful data extraction capabilities from Google BigQuery, with features for cost control and efficient data retrieval. For authentication support, reach out on the Gumloop Forum.