SquirrelSQL

SquirrelSQL is a simple JDBC client which executes SQL queries against many different relational databases. Here's how to add the CDAP JDBC driver inside SquirrelSQL.

1. Open the Drivers pane, located on the far left corner of SquirrelSQL.

2. On the Drivers pane, click the + icon.
   
   

   Open

   

    

3. Add a new Driver by typing a Name, such as CDAP Driver. The Example URL is of the form jdbc:cdap://<host>:11015?auth.token=<token>. The Website URL can be left blank. In the Class Name field, type io.cdap.cdap.explore.jdbc.ExploreDriver. Click the Extra Class Path tab, and then click Add, and for the path, type io.cdap.cdap.cdap-explore-jdbc-<version>.jar.
   
   

   Open

   

    

4. Click OK. On the Drivers pane of SquirrelSQL, Cask CDAP Driver appears in the list of drivers.

5. We can now create an alias to connect to a running instance of CDAP. To create a new alias, open the Aliases pane, and click the + icon.

6. In this example, we are going to connect to a CDAP Sandbox. The name of our alias will be CDAP Sandbox. Select CDAP Driver in the list of available drivers. Our URL will be jdbc:cdap://localhost:11015. Our CDAP Sandbox instance does not require an authentication token, but if yours requires one, HTML-encode your token and pass it as a parameter of the URL. Leave User Name and Password blank.
   
   

    

7. Click OK. CDAP Sandbox is added to the list of aliases.

8. A popup asks you to connect to your newly-added alias. Click Connect. SquirrelSQL retrieves information about your running CDAP datasets.

9. To execute a SQL query on your CDAP datasets, go to the SQL tab, enter a query in the center field, and click the "running man" icon on top of the tab. Your results appear in the bottom half of the SquirrelSQL main view.