READ_ONLY_EXTERNAL_METASTORE

Applies to: check marked yes Databricks SQL

If Databricks SQL is set up to include an external Hive metastore this configuration parameter controls whether the metastore is treated as read only.

Settings

  • TRUE

    The external Hive metastore is treated as read only.

  • FALSE

    You can modify objects in the external Hive metastore.

This parameter can’t be set at the session level. To set it at the global level, see Configure SQL parameters or the SQL Warehouse API.

System default

The system default for this setting is FALSE.