Snowflake Tags allow users to organize and categorize Snowflake objects such as tables, views, and databases. Tags are themselves physical objects that act as metadata labels for other database assets enabling easier management, organization, and control of data within the Snowflake environment.

In SqlDBM, users can manage their Snowflake Tags like any other database object and assign them using the diagrams and through object properties.

Reverse Engineer Tags

Tags can be added to a project through standard Reverse Engineering. Please ensure that your role has the required permissions to reference Tag DDL.

Create Tag

Tags can be created in a project in the Database Explorer.

Click on the three-dot menu next to Tags, click "Create New," and proceed to add details in the Properties Panel.

Manage Tag Properties

Tag properties can be maintained in the Properties panel for a selected Tag. These include

• Schema

• Name

• List of values - leave this blank to allow any-value tags

• Color (for display in SqlDBM)

• Description (DDL comment)

• Tagged Objects (for reference)

Forward engineer tags

Tag objects and assignments can be deployed to Snowflake databases through the Forward Engineer screen.

• Create - will generate DDL for creating the Tag

• Apply tags - will apply tags on database objects being generated

• Drop - without "Create" will generate drop statements for existing tags. Together with "Create," will generate a "CREATE OR REPLACE" statement for Tag objects.

Taggable objects

The following objects can be tagged in Snowflake projects

• Schemas

• Tables

• Table columns

• Views

Tag features

Beyond handling Tag DDL in Reverse and Forward Engineering, the following features are available by request to extend the utility of tagged objects.

Tags on the diagram

Tags can be viewed and maintained visually on SqlDBM diagrams.

Tagged objects are depicted with a tag icon. Column tags are displayed to the right of the column, while table tags are shown on the bottom right of the table.

To assign a tag, right-click on the object and navigate to the "Add Tag" sub-menu to select the desired tag and tag value.

For any-value tags (those without a specified list of values), type the value in instead of selecting from a list.

Diagram filter

Diagram filters can use Tag names and values in conjunction with existing Color and (metadata) Flag filters. Ensure that the filter criteria (AND / OR) is set according to expectations.

Database documentation

Snowflake Tags are available in Database Documentation and can be used for reference and search.

Select Tags from the DB Documentation Properties panel on the right of the screen to enable the column.

To search for a Tag name or value, use the search field on the top left of the screen.

See also:

• Governance Fields

• Governance Pages