​
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:

​
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.