Databricks

Connect to Databricks to analyze and visualize your data lake insights directly in Felt.

This feature is only available to customers on the Enterprise plan. To upgrade, contact sales.

1. Create a new, read-only user on your database for Felt access

2. Click on the Library () in the toolbar

3. Click + New Source

4. Select Databricks

5. Enter Connection Details

   1. Source Name: name of the source in Felt

   2. Host: The server hostname of the cluster or SQL warehouse. You can get this from the Server Hostname value in the Advanced Options > JDBC/ODBC tab for your cluster.

   3. HTTP Path: The HTTP path of the cluster or SQL warehouse. You can get this from the HTTP Path value in the Advanced Options > JDBC/ODBC tab for your cluster.

   4. Catalog: (optional) the name of the catalog to read.

   5. Schema: (optional) the name of the database schema to read. If not provided, all schemas from the database will be read.

   6. Who can see this source?: control access to this source within Felt

6. Enter credential information

   1. Select a credential type

      1. Databricks PAT. See Databricks' documentation for Personal Access Tokens

         1. Generate a token

         2. Fill in the Personal Access Token field with it

      2. M2M OAuth. See Databricks' documentation for M2M OAuth. To grant Felt access using M2M OAuth you must:

         1. Create a Service Principal in your account or workspace and copy the client_id and client_secret

         2. Navigate to the Databricks Workspace that you want to grant Felt access to

         3. Navigate to the Catalog tab

         4. Select the Catalog

         5. Navigate to the Permissions tab

         6. Click Grant

         7. Select the Service Principal you've created for Felt

         8. Grant the SELECT , BROWSE, USE_CATALOG, and USE_SCHEMA permissions

         9. Fill in the Client ID and Client Secret fields

7. Click Connect

8. Once connected you will see a catalog of your data with previews for your new source

9. From here you can add any of these layers to your spatial dashboards!