system_schemas

Operations on a system_schemas resource.

Overview

Name	system_schemas
Type	Resource
Id	databricks_workspace.unitycatalog.system_schemas

Fields

Name	Datatype
schema	string
state	string

Methods

Name	Accessible by	Required Params	Description
list	SELECT	metastore_id, deployment_name	Gets an array of system schemas for a metastore. The caller must be an account admin or a metastore admin.
disable	EXEC	metastore_id, schema_name, deployment_name	Disables the system schema and removes it from the system catalog. The caller must be an account admin or a metastore admin.
enable	EXEC	metastore_id, schema_name, deployment_name	Enables the system schema and adds it to the system catalog. The caller must be an account admin or a metastore admin.

SELECT examples

SELECT
schema,
state
FROM databricks_workspace.unitycatalog.system_schemas
WHERE metastore_id = '{{ metastore_id }}' AND
deployment_name = '{{ deployment_name }}';