DbVisualizer SQL tool

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

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

Kyvos supports the DbVisualizer SQL tool to query on the Kyvos semantic model. 

To connect DBVisualizer to Kyvos Server, perform the following steps. 

1. Download the DbVisualizer tool.  

2. Install and launch DbVisualizer. 

3. Configure the Hive driver.

   For this, do the following: 

   1. If you don't have the Hive driver, go to Tools > Driver Manager and search for Hive driver from the list. Click the link and then Download it. 
      
      

      Open

      

      OR
      If you already have the Hive driver, add the driver file from the location where you have saved the driver. To add the driver, go to Tools > Driver Manager and search for Hive driver from the list. After selecting the driver, click the Plus sign to add the driver file, and click ok. 

      Open

      

       

   2. Go to the DbVisualizer Home page, and select Create new Database connection.

4. After adding the Hive driver, enter the following information to create a new connection:

   1. Name: Provide a connection name. 

   2. Settings Format: Select Database URL.

   3. Driver Type: Select Hive.

   4. Database URL: jdbc:hive2//hostname:port/;transportMode=http;httpPath=kyvos/sql
      In the case of SSL enabled server, enter the URL as: jdbc:hive2//hostname:port/;transportMode=http;httpPath=kyvos/sql; ssl=true

   5. Provide your respected Database user and password.

   6. Click Connect to initiate the connection.

5. After establishing the connection, you can run SQL queries on the Kyvos semantic model using the SQL commander.

Running a SQL query 

1. Go to SQL Commander Tab > select New SQL Commander. 

2. Select the required connection from the Database Connection list on which you want to run a query.   

3. Write a SQL query on the right of the window. Select the query, and then click Execute the Buffer as an SQL Script. Alternatively, you can also press the CTRL+ Enter key to execute the SQL query. 

   
   You will see the result for the executed SQL query.