Application Default Credentials Authentication JTdCJTIydGl0bGUlMjIlM0ElMjJBcHBsaWNhdGlvbiUyMERlZmF1bHQlMjBDcmVkZW50aWFscyUyMEF1dGhlbnRpY2F0aW9uJTIwJTIyJTdE

From the Toolbox, click Setup, then Connections.
From the Actions menu ( ⋮ ) click Add Connection.
Enter a name or select it from the Connection list.
Select Warehouse from the Category List.
There may be more than one warehouse connection.
For Providers, select BigQuery.
Specify the Server to access Google APIs. For example, https://www.googleapis.com.
Specify the Port to use.
Enter your Project ID for the Google Cloud Platform.
To generate Temporary Views in Separate Dataset when performing the validation/preview operation from Kyvos on Google BigQuery, provide the Materialization Project and Materialization Dataset names.
From the Authentication Type, select Application Default Credentials option.
By default, Use as Source checkbox is selected as this connection can only be used to read data (creating datasets) on which the semantic model will be created.
Select Is Default SQL Engine checkbox to use the default connection.
Enter the JDBC URL for Big Query connection.
Click the Test button from the top left to validate the connection settings.
If the connection is valid, click the Save button.

Google Service Account Authentication JTdCJTIydGl0bGUlMjIlM0ElMjJHb29nbGUlMjBTZXJ2aWNlJTIwQWNjb3VudCUyMEF1dGhlbnRpY2F0aW9uJTIwJTIyJTdE

:note:atlassian-note#DEEBFF

Note

Before you proceed to create a connection, ensure that the Private key JSON file must be placed at olapengine/bin of the BI Server node.
To create Service account private key, refer to Google documentation.

From the Toolbox, click Setup, then Connections.
From the Actions menu ( ⋮ ) click Add Connection.
Enter a name or select it from the Connection list.
Select Warehouse from the Category List.
There may be more than one warehouse connection.
For Providers, select BigQuery.
Specify the Server to access Google APIs. For example, https://www.googleapis.com.
Specify the Port to use.
Enter your Google Project ID for the Google Cloud Platform.
To generate Temporary Views in Separate Dataset when performing the validation/preview operation from Kyvos on Google BigQuery, provide the Materialization Project and Materialization Dataset names.
From the Authentication Type, select Application Default Credentials or Google Service Account option and provide:
1. Service Account Email: Provide the email of the service account to be used for authentication.
2. Service Account Private Key Path: Provide the name of the private key JSON file to be used for authentication.
  Ensure that the Private key JSON file must be placed at olapengine/bin of the BI Server node.
By default, Use as Source checkbox is selected as this connection can only be used to read data (creating datasets) on which the semantic models will be created.
Select Is Default SQL Engine checkbox to use the default connection.
Enter the JDBC URL for Big Query connection.
Click the Test button from the top left to validate the connection settings.
If the connection is valid, click the Save button.
Go to the Datalake Connection and search for spark.yarn.dist.files in the connection Properties. Provide a comma-separated list of the name of service account JSON files.
NOTE: DO NOT delete any existing paths available in this field.
Restart the BI Server.

Browser not supported