{"type":"doc","content":[{"type":"paragraph","content":[{"text":"Applies to","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos Enterprise ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos Cloud (SaaS on AWS) ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos AWS Marketplace","type":"text"}]},{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos Azure Marketplace ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos GCP Marketplace ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos Single Node Installation (Kyvos SNI) ","type":"text"}]},{"type":"rule"},{"type":"paragraph","content":[{"text":"Kyvos supports raw data querying connections such as Presto, Spark, and Hive. You can also enable Snowflake and ","type":"text"},{"text":"Athena","type":"text","marks":[{"type":"link","attrs":{"href":"https://documentation.kyvosinsights.com/display/KD20233/Working+with+Athena+Connection"}}]},{"text":" for raw data querying. ","type":"text"}]},{"type":"panel","attrs":{"panelIconId":"atlassian-note","panelIcon":":note:","panelColor":"#DEEBFF","panelType":"custom"},"content":[{"type":"paragraph","content":[{"text":"Note","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"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 ","type":"text"},{"text":"Working with non-materialized or raw data semantic models","type":"text","marks":[{"type":"link","attrs":{"href":"https://kyvosdocumentation.atlassian.net/wiki/spaces/KD20233/pages/16352589"}}]},{"text":" section for more details. ","type":"text"}]}]},{"type":"paragraph","content":[{"text":"To create a Presto connection, perform the following steps. ","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"From the Toolbox, click ","type":"text"},{"text":"Setup","type":"text","marks":[{"type":"strong"}]},{"text":", then ","type":"text"},{"text":"Connections","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"From the Actions menu ( ","type":"text"},{"text":"⋮","type":"text","marks":[{"type":"strong"}]},{"text":" ) click ","type":"text"},{"text":"Add Connection","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"After you finish configuring the settings using the table shown below the screenshot, click the ","type":"text"},{"text":"Test ","type":"text","marks":[{"type":"strong"}]},{"text":" button from the top left to validate the connection settings.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If the connection is valid, click the ","type":"text"},{"text":"Save ","type":"text","marks":[{"type":"strong"}]},{"text":"button. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter the following details:","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

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.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"table","attrs":{"layout":"full-width"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[175.06]},"content":[{"type":"paragraph","content":[{"text":"Parameter/Field","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[1104.68]},"content":[{"type":"paragraph","content":[{"text":"Comments/Description","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[175.06]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"Name","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1104.68]},"content":[{"type":"paragraph","content":[{"text":"Enter a unique name for the connection.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[175.06]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"Category","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1104.68]},"content":[{"type":"paragraph","content":[{"text":"Select the","type":"text"},{"text":" ","type":"text"},{"text":" ","type":"text"},{"text":"SQL Engine ","type":"text","marks":[{"type":"strong"}]},{"text":"option. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[175.06]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"Provider","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}},{"type":"strong"}]},{"text":" ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1104.68]},"content":[{"type":"paragraph","content":[{"text":"Select the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"Presto ","type":"text","marks":[{"type":"strong"},{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"option.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[175.06]},"content":[{"type":"paragraph","content":[{"text":"Server ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1104.68]},"content":[{"type":"paragraph","content":[{"text":"Enter the server address to access your raw data. ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"type":"hardBreak"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[175.06]},"content":[{"type":"paragraph","content":[{"text":"Port","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1104.68]},"content":[{"type":"paragraph","content":[{"text":"Enter the port number to use. ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]},{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"NOTE","type":"text","marks":[{"type":"strong"},{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":": This is the port number on which your raw data is configured.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[175.06]},"content":[{"type":"paragraph","content":[{"text":"Catalog","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1104.68]},"content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"Enter the data source registered in Hive.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[175.06]},"content":[{"type":"paragraph","content":[{"text":"Authentication Type ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1104.68]},"content":[{"type":"paragraph","content":[{"text":" Select the ","type":"text"},{"text":"Kerberos","type":"text","marks":[{"type":"strong"}]},{"text":" option. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[175.06]},"content":[{"type":"paragraph","content":[{"text":"User Name","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1104.68]},"content":[{"type":"paragraph","content":[{"text":"Enter your Kerberos account user name. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[175.06]},"content":[{"type":"paragraph","content":[{"text":"Version ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1104.68]},"content":[{"type":"paragraph","content":[{"text":"Enter your Kerberos version. ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[175.06]},"content":[{"type":"paragraph","content":[{"text":"Use as source","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1104.68]},"content":[{"type":"paragraph","content":[{"text":"By default, the ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"Use as source","type":"text","marks":[{"type":"strong"},{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":" checkbox is selected as this connection can only be used to read data (creating registered datasets) on which the semantic model will be created.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":" ","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[175.06]},"content":[{"type":"paragraph","content":[{"text":"Is Default SQL Engine ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1104.68]},"content":[{"type":"paragraph","content":[{"text":"Select the checkbox if your connection type supports raw data querying.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":" ","type":"text"},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172B4D"}}]},{"text":" ","type":"text"},{"text":"See the","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":" ","type":"text"},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":" ","type":"text"},{"text":"Provider parameters table","type":"text","marks":[{"type":"link","attrs":{"href":"https://documentation.kyvosinsights.com/display/KD2023/Provider+parameters+table"}}]},{"text":" ","type":"text"},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":" ","type":"text"},{"text":"for details.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[175.06]},"content":[{"type":"paragraph","content":[{"text":"Properties ","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[1104.68]},"content":[{"type":"paragraph","content":[{"text":"Click","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"Properties","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]},{"text":"to view or set properties.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]}]}],"version":1},"reason":"A table in list item can't be created or edited in the new editor."}}}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":600,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":978,"id":"8d202c69-31fd-441b-b7f3-bed088a0b786","collection":"contentId-237736104","type":"file","height":957},"marks":[{"type":"border","attrs":{"size":1,"color":"#091e4224"}}]}]},{"type":"paragraph"}],"version":1}

Browser not supported