Databricks

A Databricks SQL client that belongs on a Mac.

DBClient talks to a SQL warehouse over HTTPS with an access token — no client to install, one Unity Catalog per connection.

Download for macOS See every feature

Free for the databases on your Mac. Pricing

Databricks

What Databricks gets.

The kinds of object that exist on an engine are the kinds the app shows. This is Databricks's row of the features table, and what stands behind it.

EngineEditable gridDesignersUsers & RolesDiagram
Databricks SQL warehouses✓managed tables✓Delta tables, views, routines✓✓

No client to install

Databricks needs no client library: the app talks to a SQL warehouse over HTTPS, with the certificate always verified.

Guide: Databricks in the docs

Delta tables, views and routines

Designers for Delta tables, views and routines, and managed tables are editable in the grid. Databricks tables have no conventional indexes, and the designer says so.

Guide: the table designer

Principals and permissions

Databricks accounts come from outside the database, so they can be granted to but not created. The sidebar lists them under Principals & Permissions.

Guide: users and roles

Each request on its own

Each request runs on its own, so interactive transactions and temporary objects are not available, and the connection is direct: no SSH or proxy tunnels.

Guide: Databricks in the docs
Connect

Connect to Databricks.

Click Add Connection under the sidebar and pick the Databricks tile. Paste a connection string — the field reads databricks:// addresses — or fill in Host, Warehouse ID, Catalog, Schema and an Access Token. Click Test Connection, then Add.

Connects to
A SQL warehouse over HTTPS on port 443, certificate always verified.
Fields
Host, Warehouse ID, Catalog, Schema and an Access Token. One Unity Catalog per connection.
Console
dbsqlcli — pip install databricks-sql-cli
Notes
Each request runs on its own, so interactive transactions and temporary objects are not available. No SSH or proxy tunnels: the connection is direct.

Guide: Databricks in the docs Guide: your first connection

Every engine

One app for the rest of your databases, too.

Every feature is built against one driver contract, so the grid, the designers and the assistant work the same whichever server you open next.

PostgreSQL MySQL MariaDB SQLite SQL Server Oracle IBM Db2 MongoDB Redis DuckDBand CSV files ClickHouse Databricks

Try it on your own database.

Free for the databases on your Mac, and never asking you to sign in.

Download DBClient

$brew install --cask az-code-lab/taps/dbclient