Applies to: Kyvos Enterprise Kyvos Cloud (Managed Services Kyvos Cloud (SaaS on AWS) Kyvos Azure AWS Marketplace
Kyvos AWS Azure Marketplace Kyvos Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI) Kyvos Free (Limited offering for AWS)
...
Kyvos supports both ROLAP and HOLAP on BigQuery connections. You can use this connection for querying data from your BigQuery data warehouse.
Info |
---|
Info
|
To set up or view a BigQuery warehouse connection, perform the following steps.
From the Toolbox, click Connections.
From
...
the Actions menu ( ⋮ ) click Add Connection.
Enter a name or select it from the Connection list.
After you have entered the parameters described in the table below,
...
click the Test button from the top left to validate the connection settings.
If the connection is valid, click the Save button.
To refresh connections, click the Actions menu ( ⋮ ) at the top of the Connections column and select Refresh.
Aura tab collection | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Aura tab | ||
---|---|---|
|
params | JTdCJTIyZ2VuZXJhbCUyMiUzQSU3QiUyMnRhYlNwYWNpbmclMjIlM0EwJTJDJTIydGFiV2lkdGglMjIlM0ExMDAlMkMlMjJ0YWJIZWlnaHQlMjIlM0E1MCUyQyUyMmRpcmVjdGlvbiUyMiUzQSUyMmhvcml6b250YWwlMjIlN0QlMkMlMjJjb250ZW50JTIyJTNBJTdCJTIyYmFja2dyb3VuZENvbG9yJTIyJTNBJTdCJTIyY29sb3IlMjIlM0ElMjIlMjNmZmYlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTJDJTIydG9wJTIyJTNBdHJ1ZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBdHJ1ZSUyQyUyMnJpZ2h0JTIyJTNBdHJ1ZSUyQyUyMmNvbG9yJTIyJTNBJTdCJTIybGlnaHQlMjIlM0ElMjIlMjNjY2NlY2YlMjIlN0QlN0QlMkMlMjJwYWRkaW5nJTIyJTNBJTdCJTIydG9wJTIyJTNBMTAlMkMlMjJyaWdodCUyMiUzQTEwJTJDJTIyYm90dG9tJTIyJTNBMTAlMkMlMjJsZWZ0JTIyJTNBMTAlN0QlN0QlMkMlMjJhY3RpdmUlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzZjU4MjI3JTIyJTdEJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIydGV4dEFsaWduJTIyJTNBJTIybGVmdCUyMiUyQyUyMmZvbnRXZWlnaHQlMjIlM0ElMjJib2xkJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kQ29sb3IlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSUyMiUyM2RmZTFlNiUyMiU3RCUyQyUyMnRleHQlMjIlM0ElN0IlMjJmb250U2l6ZSUyMiUzQTE4JTJDJTIyY29sb3IlMjIlM0ElMjIlMjM1ZTZjODQlMjIlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMmxpZ2h0ZXIlMjIlN0QlN0QlMkMlMjJpbmFjdGl2ZSUyMiUzQSU3QiUyMmJhY2tncm91bmRDb2xvciUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzZjRmNWY3JTIyJTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmZvbnRTaXplJTIyJTNBMTYlMkMlMjJjb2xvciUyMiUzQSUyMiUyMzVlNmM4NCUyMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybGlnaHRlciUyMiU3RCU3RCU3RA== |
---|
Aura tab | ||||
---|---|---|---|---|
|
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 option.
By default, Is Read checkbox is selected as this connection can only be used to read data (creating registered files) on which the cube will be created.
Click Properties to configure advanced settings. For example, to enable Views in BigQuery set the value for viewsEnabled as true.
Click the Test button from the top left to validate the connection settings.
If the connection is valid, click the Save button.
Aura tab | ||||
---|---|---|---|---|
|
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
Note Before you proceed to create a connection, ensure that the Private key JSON file must be placed at olaengine/bin of the BI Server node. |
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:
OAuth Service Account Email: Provide the email of the service account to be used for authentication.
OAuth 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 olaengine/bin of the BI Server node.
By default, Is Read checkbox is selected as this connection can only be used to read data (creating registered files) on which the cube will be created.
Click Properties to configure advanced settings. For example, to enable Views in BigQuery set the value for viewsEnabled as true.
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.