Integrating DBeaver with Lakehouse SQL
DBeaver is an open-source database tool for developers, analysts, and database administrators. It supports Databricks as well as other popular databases. You can use the SkyPoint Cloud Lakehouse SQL tool to run SQL commands and browse database objects in Databricks. Also, you can perform CRUD (Create, Read, Update, and Delete) operations using an SQL server.
Follow the below steps to integrate DBeaver with Lakehouse SQL:
Step 1: Install DBeaver and Download Databricks JDBC Driver
Follow the below steps to install DBeaver and Download Databricks JDBC Driver:
Download DBeaver from https://dbeaver.io/download/. Choose Dbeaver Community 22.2.0, run the process, and set up the tool. You download the latest version. This article is tested with version 22.2.0.
Download the Databricks JDBC Driver onto your local development machine. Extract the
databricksJDBC42.jarfile from the downloaded
Once DBeaver is installed, follow the below steps to configure and work with databases in Lakehouse SQL.
Step 2: Configure the Databricks JDBC Driver for DBeaver
Set up DBeaver with information about the Databricks JDBC Driver that you downloaded earlier.
- Start DBeaver.
- If you are prompted to create a new database, click No.
- If you are prompted to connect to or select a database, click Cancel.
- Click Database > Driver Manager.
- In the Driver Manager dialog box, click New.
- In the Create new driver dialog box, click the Libraries tab.
- Click Add File.
- Browse to the
databricksJDBC42.jarfile that you extracted earlier and click Open.
- Click Find Class.
- In the Driver class list, confirm that com.simba.spark.jdbc.Driver is selected.
- On the Settings tab, for Driver Name, enter
- On the Settings tab, for Class Name, enter
- Click OK.
- In the Driver Manager dialog box, click Close.
Step 3: Connect DBeaver to your Lakehouse SQL endpoint
Use DBeaver to connect to the Lakehouse SQL endpoint to access the databases in your Databricks workspace.
- In DBeaver, click Database > New Database Connection.
- In the Connect to a database dialog box, on the All tab, click Azure Databricks (Native), and then click Next.
- Click the Main tab and enter credentials to connect.
- To find credentials such as JDBC URL and Personal access token, follow the below steps:
- Open SkyPoint Cloud Studio.
- In the left pane, go to Lakehouse > SQL Access.
- Click Show fields to copy your credentials to your clipboard. For more information, refer to Getting started with SkyPoint Cloud Lakehouse SQL.
- Enter JDBC URL and do the following:
|Validate Username||Type token. This token is just the word token only.|
|Validate Password||Enter the Personal Access token that you have taken from the SkyPoint Cloud Platform.|
- Check Save password locally.
- Click Test Connection.
- If the connection succeeds, click OK in the Connection Test dialog box.
- In the Connect to a database dialog box, click Finish.
In the Database Navigator window, a new entry is displayed.
Step 4: Use DBeaver to browse databases and their objects
Use DBeaver to access databases and database objects in your Lakehouse SQL workspaces such as tables and table properties, views, indexes, data types, and other object types.
- In the Database Navigator window, right-click Azure Databricks.
- If Connect is enabled, click it. (If Connect is disabled, you are already connected.)
- Expand hive_metastore.
- Expand the database that you want to browse.
- Expand Tables.
- Right-click on the table you wish to query and click on read data in SQL editor.
- Repeat the instructions in this step to access additional databases and database objects.