Skip to main content

Home

Configure Databricks System Table

Pre-requisites

  1. Create a Databricks workspace with system tables enabled and add the workspace details in Unravel.

    For more details on system tables, see this page.

  2. Configure System Tables for Data Access.

    Unravel accesses data from the Billing and Pricing system tables. Complete the following configuration:

    For detailed instructions on granting privileges, refer to the following documentation:

Integrating Databricks System Tables with Unravel

Note

You must configure and enable a Databricks workspace with system table and provide its JDBC URL and workspace ID in Unravel using the following properties.

Configure the following properties for Dabaricks system tables integration.:

Property

Description

Sample Values

com.unraveldata.unitycatalog.accessor.enabled

Enables Databricks system table accessor in Unravel.

true

com.unraveldata.unitycatalog.accessor.jdbc.url

Specifies the JDBC URL for connecting to the Databricks workspace.

jdbc:databricks://dbc-f874t197-a823.cloud.databricks.com:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/warehouses/d7v51a813c7gf941;

com.unraveldata.unitycatalog.accessor.lookback.days

Sets the number of days to look back for Databricks system table data.

30

com.unraveldata.unitycatalog.accessor.workspace.id

Specifies the Workspace ID used to integrate Unravel with Databricks System tables

4083330060312460

In this section: