Connect to a Delta Lake instance
In the premium version of Databricks, it is possible to control table access. If that's the case, the user must be granted the following data object privileges:
- for reverse-engineering: READ_METADATA and SELECT on the tables and views
- for forward-engineering (apply to instance): rights to CREATE/UPDATE schema, table, and view: CREATE on the CATALOG, and either OWN or both USAGE and CREATE on the schema, tables and views.
Connecting a Databricks instance on one of the cloud providers requires to declare the connections settings and a personal access token.
You should consult this page for more information on finding Databricks workspace details.
To get the cluster ID, click the Clusters tab in sidebar and then select a cluster name. The cluster ID is the number after the /clusters/ component in the URL of this page:
https://<databricks-instance>/#/setting/clusters/<cluster-id>
In the following screenshot, the cluster ID is 1115-164516-often242:
Hackolade uses the Databricks REST API, and requires that an access token be issued in the Databricks console under User Settings > Generate New Token. For more information, please consult this page. The access token must be pasted in the field below. Access token management is described here.