Purpose

Specifies the full path to the .json or .p12 private key file that contains the key required to authenticate to a Google BigQuery instance when service account authentication is enabled (AuthenticationMethod=serviceaccount). You can dowload the private key file from Google Cloud Platform (GCP) Console.

To learn more about service accounts and service account private keys, refer to Google documentation.

Valid Values

string

where:

string
is the full path to the .json or .p12 private key file.

Notes

  • Either ServiceAccountKeyContent or ServiceAccountPrivateKey may be used to configure service account authentication. ServiceAccountKeyContent specifies the private key itself, whereas ServiceAccountPrivateKey specifies the full path to the .json or .p12 file that contains the private key. When ServiceAccountKeyContent is used, the specified private key is used to authenticate the user with the database. When ServiceAccountPrivateKey is used, the driver extracts the private key value from the specified file and uses it to authenticate the user to the database. If you do not want to persist the private key file in your environment, you should use the ServiceAccountKeyContent property. If ServiceAccountKeyContent and ServiceAccountPrivateKey are both specified, the ServiceAccountKeyContent property will be used to connect to Google BigQuery.

Data Source Method

setServiceAccountPrivateKey

Default

None

Data Type

String

See also

Configuring service account authentication

ServiceAccountEmail

ServiceAccountKeyContent

Service account properties