Applies to: 
Kyvos Enterprise Kyvos Cloud Kyvos Azure Marketplace
Kyvos Single Node Standard Installation Kyvos Single Node Installation Kyvos Free
Kyvos supports raw data querying connections such as Presto, Spark, and Hive. You can also enable Snowflake and Athena for raw data querying.
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 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
Name Enter a unique name for the connection. Category Select the SQL Engine option. Provider Select the Presto option. Server Enter the server address to access your raw data. Port Enter the port number to use.
NOTE: This is the port number on which your raw data is configured.
Catalog Enter the data source registered in Hive. Authentication Type Select the Kerberos option. User Name Enter your Kerberos account user name.
Version Enter your Kerberos version. Use as source By default, the Use as source checkbox is selected as this connection can only be used to read data (creating registered datasets) on which the semantic model will be created. Is Default SQL Engine Select the checkbox if your connection type supports raw data querying. See the Provider parameters table for details. Properties Click Properties to view or set properties.
Presto connection