Data access configuration

Preview

This feature is in Public Preview. Contact your Databricks representative to request access.

This article describes the data access configurations performed by Databricks SQL Analytics administrators for all SQL endpoints.

Important

Changing these settings restarts all running SQL endpoints.

Allow endpoints to access storage

The instance profile setting allows a Databricks SQL Analytics administrator to configure all endpoints to use an AWS instance profile when accessing AWS storage.

  1. Click the User Settings Icon icon at the bottom of the sidebar and select Settings.
  2. Click the SQL Endpoint Settings tab.
  3. In the Instance Profile drop-down, select an instance profile. If there are no profiles, click Configure to open the Databricks Admin Console in a new tab to configure an instance profile.
  4. Click Save.

Important

If the instance profile is invalid, all SQL endpoints will become unhealthy.

Data access properties

The data access setting allows a Databricks SQL Analytics administrator to configure all endpoints with data access properties.

  1. Click the User Settings Icon icon at the bottom of the sidebar and select Settings.
  2. Click the SQL Endpoint Settings tab.
  3. In the Data Access Configuration textbox, specify key-value pairs containing metastore properties.
  4. Click Save.

Supported properties

  • spark.databricks.hive.metastore.glueCatalog.enabled:
  • spark.sql.hive.metastore.*:
  • spark.sql.warehouse.dir:
  • spark.hadoop.aws.region:
  • spark.hadoop.datanucleus.*:
  • spark.hadoop.fs.*:
  • spark.hadoop.hive.*:
  • spark.hadoop.javax.jdo.option.*:
  • spark.hive.*:

For details on how to set these properties, see External Hive metastore and AWS Glue data catalog.