Page Comparison

Name

No

Required. Name of the connection. Connection names must be unique in a namespace. Connection names can only include letters, numbers, underscores, and hyphens.

Description

No

Optional. Description of the connection.

Project ID

Yes

Google Cloud Project ID, which uniquely identifies a project. This is where the BigQuery job will be run to query the data. It can be found on the Dashboard in the Google Cloud Platform Console. Make sure the service account specified below has the permission to run BigQuery jobs in this project by granting the service account the BigQuery Job User role.

Default is auto-detect.

Dataset Project ID

Yes

Google Cloud Project ID of the project where your dataset is. It can be found on the Dashboard in the Google Cloud Platform Console. Make sure the service account specified below has the permission to view data in this project by granting the service account the BigQuery Data Viewer role.

Show Hidden Datasets

Yes

Optional. Whether to show hidden datasets.

Service Account Type

Yes

Required. Select one of the following options:

• File Path. File path where the service account is located.

• JSON. JSON content of the service account.

Service Account File Path

Yes

Required. Path on the local file system of the service account key used for authorization. Can be set to 'auto-detect' when running on a Dataproc cluster. When running on other clusters, the file must be present on every node in the cluster.

Default is auto-detect.

Service Account JSON

Yes

Required. Content of the service account.