home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Databricks

Create a Looker user

Looker authenticates to Databricks by personal access tokens. Follow the Databricks documentation to create a personal access token for a Databricks user to use in Looker.

Add permissions to this user with GRANT.

At a minimum, the Looker user should have SELECT and READ_METADATA.

GRANT SELECT ON DATABASE <YOUR_DATABASE> TO <looker>@<your.databricks.com> GRANT READ_METADATA ON DATABASE <YOUR_DATABASE> TO <looker>@<your.databricks.com>

Server information

Follow the Databricks documentation to find the HTTP Path for your Databricks cluster. This will be referred to as <YOUR_HTTP_PATH> on this page.

Setting up persistent derived tables

To use persistent derived tables, create a separate database.

CREATE DATABASE <YOUR_SCRATCH_DATABASE>

This will also require addional write-based user permissions to be granted.

GRANT SELECT CREATE MODIFY ON DATABASE <YOUR_SCRATCH_DATABASE> TO <looker>@<your.databricks.com> GRANT READ_METADATA ON DATABASE <YOUR_SCRATCH_DATABASE> TO <looker>@<your.databricks.com>

Setting up the Looker connection

In the Admin section of Looker, select Connections, and then select New Connection.

Click Test These Settings to test the connection and make sure that it is configured correctly. If you see Can Connect, then press Add Connection. This runs the rest of the connection tests to verify that the service account was set up correctly and with the proper roles.

For more information about connection settings, see the Connecting Looker to your database documentation page.

Feature support

For Looker to support some features, your database dialect must also support them.

Databricks supports the following Looker features:

Next steps

After you have completed the database configuration, connect to the database from Looker.


Top