Pular para o conteúdo principal
Última atualização em

UNSET TAG

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 16.1 and above

Removes a tag on a catalog, schema, table, view, volume, column, function, or external metadata object.

Public Preview

Removing tags from external metadata objects is in Public Preview and requires Databricks Runtime 18.2 or above.

To remove tags from Unity Catalog securable objects, you must own the object or have all of the following privileges:

  • APPLY TAG on the object
  • USE SCHEMA on the object's parent schema
  • USE CATALOG on the object's parent catalog

External metadata objects are not contained in a catalog or schema, so USE CATALOG and USE SCHEMA do not apply.

Syntax​

UNSET TAG ON
    { CATALOG catalog_name |
      COLUMN relation_name . column_name |
      EXTERNAL METADATA external_metadata_name |
      { FUNCTION | PROCEDURE } function_name |
      { SCHEMA | DATABASE } schema_name |
      TABLE relation_name |
      VIEW  relation_name |
      VOLUME volume_name }
    tag_key

Parameters​

  • CATALOG catalog_name

    The name of the catalog from which to remove the tag.

  • COLUMN relation_name . column_name

    The qualified name of the column from which to remove the tag. relation_name must identify a view or a table. The relation_name must not include a temporal specification or options specification.

  • EXTERNAL METADATA external_metadata_name

    The name of the external metadata object from which to remove the tag.

  • { FUNCTION | PROCEDURE } function_name

    The name of the function or procedure from which to remove the tag.

    nota

    Tagging functions and procedures requires Databricks Runtime 18.1 or above.

  • SCHEMA schema_name

    The name of the schema from which to remove the tag.

  • TABLE relation_name

    The name of the table, or view from which to remove the tag. The name must not include a temporal specification or options specification.

  • VIEW relation_name

    The name of the view from which to remove the tag.

  • VOLUME volume_name

    The name of the volume from which to remove the tag.

  • tag_key

    An identifier. If the tag cannot be found an exception is raised.

Examples​

SQL
> SET TAG ON CATALOG catalog `cost_center` = `hr`;

> UNSET TAG ON CATALOG catalog cost_center;

> SET TAG ON TABLE catalog.schema.table cost_center = hr;

> UNSET TAG ON TABLE catalog.schema.table cost_center;

> SET TAG ON COLUMN table.ssn pii;

> UNSET TAG ON COLUMN table.ssn pii;

> SET TAG ON FUNCTION catalog.schema.my_func cost_center = hr;

> UNSET TAG ON FUNCTION catalog.schema.my_func cost_center;
Nesta página