Applies to: Kyvos Enterprise Kyvos Azure Marketplace
Kyvos AWS Marketplace Kyvos Free (
...
Data connections are used to connect to Kyvos cluster data, for example, to do computations and also to connect to your data.
...
- From the Toolbox, click Setup, then choose Connections.
- From the Actions menu ( ⋮ ), click Add Connection.
- Enter a Name for the connection.
- Choose the Category from the drop-down list.
- Select the Provider from the drop-down list.
The other options change based on your selection. - See the Provider parameters table for details.
- To test the connection, click the Test button at the top of the dialog box. If the status is Invalid, click Invalid to learn more.
- Click Save when you are finished.
...
Separate read and build connections
On non-SSH and Livy-enabled Azure and GCP clusters, Kyvos allows you to create separate build and read connections for launching build jobs and reading data.
...
When you define a new connection on non-SSH and Livy-enabled Azure and GCP clusters, you will see the option to choose if it is a Build connection, as shown in the following figure.
...
To use Spark or Hive for raw data querying , the Hadoop connection must have the Is Default SQL Engine checkbox disabled for other raw data connections (e.g Presto and Snowflake)
For a Spark connection, you need to provide the Spark thrift server connection string URL.
For example: jdbc:hive2://10.260.431.111:10001/default;transportMode=http;httpPath=cliservice;principal=hive/intelli-i0056.kyvostest.com@KYVOSTEST.COM