...
Open the Drivers pane, located on the far left corner of SquirrelSQL.
On the Drivers pane, click the + icon.
Add a new Driver by typing a Name, such as
CDAP Driver
. The Example URL is of the formjdbc:cdap://<host>:11015?auth.token=<token>
. The Website URL can be left blank. In the Class Name field, typeio.cdap.cdap.explore.jdbc.ExploreDriver
. Click the Extra Class Path tab, and then click Add, and for the path, typeio.cdap.cdap.cdap-explore-jdbc-<version>.jar
.Click OK. On the Drivers pane of SquirrelSQL, Cask CDAP Driver appears in the list of drivers.
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.
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 bejdbc: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 theURL
. Leave User Name and Password blank.Click OK.
CDAP Sandbox
is added to the list of aliases.A popup asks you to connect to your newly-added alias. Click Connect. SquirrelSQL retrieves information about your running CDAP datasets.
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.