Google BigQuery
Query Google BigQuery using a service account. Review required fields, credential setup and how this connector works in Zild.
Query Google BigQuery using a service account.
Where to configure
Open Zild Admin → Integrations → Connectors, find the provider and use Configure or Edit. Enter the data from this guide, enable the connector for the workflow and save.
Required fields
These requirements are the data needed by the workflow using the connector. Generic saving may accept empty fields that are only required when an operation runs. Saving does not confirm that the provider accepts the credential.
| Field | Workflow requirement |
|---|---|
CredentialsJson | Complete service account key JSON, including project_id, client_email and private_key. |
How to obtain credentials
- In Google Cloud, select the project and open IAM & Admin → Service Accounts.
- Select the service account, open Keys → Add key → Create new key and choose JSON.
- Enter the entire file contents in CredentialsJson. Grant access to datasets and permission to create query jobs in the project.
How it works in Zild
The API extracts project_id from the JSON, creates GoogleCredential and BigQueryClient, and executes the query. The form does not use ApiKey for this type.
How to verify the configuration
After saving, use the matching workflow (query, agent, call or processing) to verify access. If it fails, check the credential, permissions and selected provider resource. For limited or legacy types, confirm availability with your administrator before use.
When editing, Zild displays protected credentials as asterisks. Preserve the masked value to keep the current credential or paste a new credential to replace it.