​

Authentication

This provider requires authentication.

• service_account_json: The service account JSON with container.viewer role (required: True, sensitive: True)
• project_id: Google Cloud project ID. If not provided, it will try to fetch it from the environment variable ‘GOOGLE_CLOUD_PROJECT’ (required: False, sensitive: False)

​

In workflows

This provider can be used in workflows.

As “step” to query data, example:

steps:
    - name: Query bigquery
      provider: bigquery
      config: "{{ provider.my_provider_name }}"
      with:
        query: {value}  

Check the following workflow examples:

• bigquery.yml
• failed-to-login-workflow.yml

​

Connecting with the Provider

1. Create a Google Cloud project and enable the BigQuery API.
2. Create a service account in your Google Cloud project and download the JSON key file.
3. Share the necessary datasets with the service account.
4. Configure your provider using the service_account_key, project_id, and dataset.