...
Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Important With the Kyvos 2024.11 release, you will not be able to create a Presto connection from the Kyvos User Interface. However, you can still establish a Presto connection by performing following manual steps. |
Kyvos supports raw data querying connections such as Presto, Spark, and Hive. You can also enable Snowflake and Athena for for raw data querying.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Note You can create multiple Presto connections for raw data querying. The connections are available on the semantic model designer page, where you can select the connection to be used for querying a particular semantic model. See the Working with non-materialized or raw data semantic models section section for more details. |
To create a Presto connection, perform the following manual steps.
...
From the Toolbox, click Setup, then Connections.
...
From the Actions menu ( ⋮ ) click Add Connection.
...
After you finish configuring the settings using the table shown below the screenshot, click the Test button from the top left to validate the connection settings.
...
If the connection is valid, click the Save button.
Enter the following details:
...
Parameter/Field
...
Comments/Description
...
Enter the port number to use.
NOTE: This is the port number on which your raw data is configured.
...
Enter your Kerberos account user name.
...
Login to Kyvos Manager.
Go to Utilities > Manage Configuration Files.
On the Manage Configuration Files, expand BI Server > kyvos/olapengine/conf/ folder.
Download providerInfo.xml file. After downloading the file,
For on-premises deployment, copy this jar to all the Kyvos nodes at path : <ENGINE_HOME>/lib/.
For cloud deployment:
Copy this jar to Kyvos Manager node at the<ENGINE_HOME>/lib/ path.
Update BI Server Libraries snapshot from Kyvos Manager. Go to Utilities > Update Snapshot Bundles.
Upload the file.
Now, download the presto-jdbc jar fie.
After Perform below mentioned steps for above downloaded jar:
Restart Kyvos services.