Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Applies to:  Image Removed Kyvos Enterprise   Image Removed Kyvos Cloud   Image Removed Kyvos Azure Marketplace  

Image Removed Kyvos Single Node Standard Installation  Image Removed Kyvos Single Node Installation  Image Removed Kyvos FreeApplies to: (tick) Kyvos Enterprise  (tick) Kyvos Cloud (SaaS on AWS) (tick) Kyvos AWS Marketplace

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

...

Kyvos supports raw data querying connections such as Presto, Spark, and Hive. You can also enable Snowflake and  and  Athena  for  for raw data querying. 

...

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

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  the  Working with non-materialized or raw data semantic models  section for more details. 

To create a Presto connection, perform the following steps. 

  1. From the Toolbox, click Setup, then Connections.

  2. From the Actions menu (  ) click Add Connection.

  3. After you finish configuring the settings using the table shown below the screenshot,

...

  1. click the  Test  button from the top left to validate the connection settings.

  2. If the connection is valid, click

...

  1. the  Save  button. 

  2. 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 sourceBy 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.

...