Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Existing Google Service Account with P12 file containing the private key. Learn how to import P12 File into the Google Service Account.

  • JDK with Keytool utility to set up the Keystore. 

...

Field Name

Field Type

Description

Label*

Default Value: None
ExampleService Account

String/Expression

Specify a unique label for the account.

Properties for Google BigQuery

Account ID*   

Default Value: None
Example: 108275755

Integer/Expression

Specify the ID of the service account available in the Google web console.

Private Key ID* 

Default Value: None
Example: 4fb718fd54de73f0

String/Expression

Specify the ID of the private key available in the Google web console.

Email ID*

Default Value: None
Example: test1@0.iam.gserviceaccount.com

String/Expression

Specify the email id of the the service account available in the Google web console.

Keystore URI*

Default Value: None
Example: g_bigq

String/Expression

Specify the location of the Keystore that contains the private key to be used. You can upload the file using the Upload icon.

Keystore Passphrase*

String/Expression

Specify the passphrase to access the Keystore.

Private Key Alias*

Default Value: None
Example: privatekey

String/Expression

Specify the alias to identify the private key. This is a suggestible field and will lists all the available aliases in the key store.

Properties for Cloud Storage

Account ID 

Default Value: None
Example: 108275755

Integer/Expression

Specify the ID of the service account available in the Google web console.

Private Key ID 

Default Value: None
Example: 4fb718fd54de73f0

String/Expression

Specify the ID of the private key available in the Google web console.

Email ID 

Default Value: None
Example: test1@0.iam.gserviceaccount.com

String/Expression

Specify the email id of the the service account available in the Google web console.

Keystore URI

Default Value: [None]
Example: g_bigq

String/Expression

Specify the location of the Keystore that contains the private key to be used. Click the browse icon to load into/select from SLDB.

Keystore Passphrase

String/Expression

Specify the passphrase to access the Keystore.

Private Key Alias 

Default Value: None
Example: privatekey

String/Expression

Specify the alias to identify the private key. This is a suggestible field and will list all the aliases in the key store.

Default Standard SQL

Checkbox

Select this checkbox if you want to default the dialect in the Query field in the Snaps using this account to Standard SQL.

Info

To override this default setting

Use the #legacySQL tag within the Query field of the Snap to treat it as a Legacy SQL query.

Importing P12 File
Anchor

...

Importing-P12-File

...

Importing-P12-

...

File

  1. Create a new Keystore.

  2. Empty the Keystore.

  3. Verify if the Keystore is empty.

  4. Import the P12 file.

  5. Check the Keystore is non-empty.

  6. Change the alias, if needed.

  7. Verify a new alias.

...