Working with Presto Connection

Applies to: Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

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 raw data querying.

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 for more details.

To create a Presto connection, perform the following manual steps.

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,
1. For on-premises deployment, copy this jar to all the Kyvos nodes at path: <ENGINE_HOME>/lib/.
2. 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.