This section guides you through the process of obtaining the private key file. A private key file must be specified when creating a data source with service account authentication.

To obtain a private key file from Google Cloud Console:

  1. Go to the APIs & Services dashboard.
  2. Click Credentials on the left.
  3. If you have not already created service account credentials, click + CREATE CREDENTIALS, and select Service account from the dropdown.
  4. Provide the required information on the Create service account page.
  5. Click the service account for which you want to obtain a private key file.
  6. Select the KEYS tab.
  7. From the ADD KEY dropdown, select Create new key, and select the format of the private key file you want to create and download. Press CREATE.

Results:

The private key file is downloaded to your local machine. The private key file should be moved to a secure location, but one that is accessible to the Hybrid Data Pipeline service. The service uses the contents of the private key file to authenticate clients with Google BigQuery. You must specify the full path to the private key file when you create your Google BigQuery data source.

Note: If you are using a P12 file, take note of the private key password and secure it.