Skip to main content

catalog_configs

Creates, updates, deletes, gets or lists a catalog_configs resource.

Overview​

Namecatalog_configs
TypeResource
Iddatabricks_workspace.dataclassification.catalog_configs

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringResource name in the format: catalogs/{catalog_name}/config.
â–¶auto_tag_configsarrayList of auto-tagging configurations for this catalog. Empty list means no auto-tagging is enabled.
â–¶excluded_schemasobjectSchemas to exclude from the scan, each named relative to the parent catalog. If specified, all schemas except the specified ones will be scanned. Mutually exclusive with ``included_schemas``: only one may be set per request. If neither ``included_schemas`` nor ``excluded_schemas`` is set, all schemas are scanned.
â–¶included_schemasobjectSchemas to include in the scan, each named relative to the parent catalog. If specified, only listed schemas will be scanned. Mutually exclusive with ``excluded_schemas``: only one may be set per request. If neither ``included_schemas`` nor ``excluded_schemas`` is set, all schemas are scanned.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectcatalog_name, deployment_name, workspace_domainGet the Data Classification configuration for a catalog.
createinsertcatalog_name, deployment_name, workspace_domainCreate Data Classification configuration for a catalog.
updateupdatecatalog_name, update_mask, deployment_name, workspace_domainUpdate the Data Classification configuration for a catalog.
deletedeletecatalog_name, deployment_name, workspace_domainDelete Data Classification configuration for a catalog.

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
catalog_namestringThe catalog_name segment of the name resource name (catalogs/{catalog_name}/config). Resource name in the format: catalogs/{catalog_name}/config
deployment_namestringThe Databricks workspace deployment name: the host prefix of the workspace URL (dbc-abcd0123-a1bc on AWS, adb-1234567890123456.7 on Azure, 1234567890123456.7 on GCP). Set DATABRICKS_DEPLOYMENT_NAME to default it for the session. (default: dbc-abcd0123-a1bc, x-stackQL-envVar: DATABRICKS_DEPLOYMENT_NAME)
update_maskobjectField mask specifying which fields to update.
workspace_domainstringThe Databricks workspace domain suffix for the cloud. Selected by DATABRICKS_CLOUD (aws, azure or gcp; default aws). (default: cloud.databricks.com, x-stackQL-envVarSelector: {"envVar":"DATABRICKS_CLOUD","default":"aws","values":{"aws":"cloud.databricks.com","azure":"azuredatabricks.net","gcp":"gcp.databricks.com"}})

SELECT examples​

Get the Data Classification configuration for a catalog.

SELECT
name,
auto_tag_configs,
excluded_schemas,
included_schemas
FROM databricks_workspace.dataclassification.catalog_configs
WHERE catalog_name = '{{ catalog_name }}' -- required
AND deployment_name = '{{ deployment_name }}' -- required
AND workspace_domain = '{{ workspace_domain }}' -- required
;

INSERT examples​

Create Data Classification configuration for a catalog.

INSERT INTO databricks_workspace.dataclassification.catalog_configs (
auto_tag_configs,
excluded_schemas,
included_schemas,
name,
catalog_name,
deployment_name,
workspace_domain
)
SELECT
'{{ auto_tag_configs }}',
'{{ excluded_schemas }}',
'{{ included_schemas }}',
'{{ name }}',
'{{ catalog_name }}',
'{{ deployment_name }}',
'{{ workspace_domain }}'
RETURNING
name,
auto_tag_configs,
excluded_schemas,
included_schemas
;

UPDATE examples​

Update the Data Classification configuration for a catalog.

UPDATE databricks_workspace.dataclassification.catalog_configs
SET
auto_tag_configs = '{{ auto_tag_configs }}',
excluded_schemas = '{{ excluded_schemas }}',
included_schemas = '{{ included_schemas }}',
name = '{{ name }}'
WHERE
catalog_name = '{{ catalog_name }}' --required
AND update_mask = '{{ update_mask }}' --required
AND deployment_name = '{{ deployment_name }}' --required
AND workspace_domain = '{{ workspace_domain }}' --required
RETURNING
name,
auto_tag_configs,
excluded_schemas,
included_schemas;

DELETE examples​

Delete Data Classification configuration for a catalog.

DELETE FROM databricks_workspace.dataclassification.catalog_configs
WHERE catalog_name = '{{ catalog_name }}' --required
AND deployment_name = '{{ deployment_name }}' --required
AND workspace_domain = '{{ workspace_domain }}' --required
;