'/%3E%3Cdefs%3E%3ClinearGradient id='paint0_linear' x1='0' y1='0' x2='0' y2='2160' gradientUnits='userSpaceOnUse'%3E%3Cstop/%3E%3Cstop offset='.1' stop-color='%23000' stop-opacity='0'/%3E%3Cstop offset='1' stop-opacity='0'/%3E%3C/linearGradient%3E%3C/defs%3E%3C/svg%3E%0A)
Read Big Query
Summary
Reads data from Google BigQuery, a cloud data warehouse. Provide your project ID and authentication details to connect to BigQuery, and then specify your query to fetch data from your datasets.
Properties
The following table lists the Read Big Query block properties and describes the input for each property.
Note: To quickly fill out all the block properties except Query, upload a JSON file generated automatically when you create a key for your service account.
The JSON file contains the following security key information:
json
For more information about creating a service account key, see here.
Property | Description |
|---|---|
| Project ID | The ID of your Google Cloud project |
| Private Key ID | The ID of the private key for the service account |
| Private Key | The private key for the service account |
| Client Email | The service-account email |
| Client ID | The client ID |
| Client Certificate URL | The URL of the client certificate |
| Query | The query to send |