Page Comparison

Label*

Default Value: None
Example: Service 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: N/A
Example: 4fb718fd54de73f0

String/Expression

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

Email ID*

Default Value: N/A
Example: test1@0.iam.gserviceaccount.com

String/Expression

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

Keystore URI*

Default Value: N/A
Example: g_bigq

String/Expression

Specify the location of the Keystore that contains the private key to be usedyou use. 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: N/A
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: N/A
Example: 108275755

Integer/Expression

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

Private Key ID 

Default Value: N/A
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: N/A
Example: test/g_bigquery

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

Default Value: N/A
Example: Encrypted value

String/Expression

Specify the passphrase to access the Keystore.

Private Key Alias 

Default Value: N/A
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

Default Value: Deselected

Checkbox

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