search
Try for free

Sync Snowflake Tags (BETA)

Automatically ingest and synchronize Snowflake tags as System-Managed Attributes in the Decube Catalog, ensuring a single source of truth for governance and discovery.

Decube eliminates manual overhead by automatically syncing Snowflake tags directly into the Data Catalog as System-Managed Attributes. This integration ensures your catalog reflects the exact business vocabulary, security tags, and departmental classifications defined in your data warehouse without any manual configuration.

By inheriting these tags from the source, Decube provides a high-fidelity global view of your data assets, reducing the risk of human error and saving governance teams hours of administrative work.

hashtag
What this feature does

  • Automatic Ingestion: Snowflake tags are automatically ingested during the regular metadata sync.

  • System-Managed Attributes: Tags appear as read-only attributes, distinct from user-created custom attributes.

  • Unified Discovery: Enables users to filter and search assets based on the synced Snowflake tags.

  • Rich Data Types: Supports various tag value types (text, enum/dropdown) as defined in Snowflake.

hashtag
Snowflake Tags Sync Behavior

circle-info

Snowflake tags are synced automatically by default. Currently, there is no option to opt-out of this sync.

  • Read-Only: Values for Snowflake tags are managed entirely at the source (Snowflake). They cannot be edited within the Decube UI.

  • Identification: In the Catalog, these tags are identified as "SourceName.Database.Schema Snowflake tags".

circle-info

This naming convention is used because Snowflake tags are not unique between Snowflake databases and schemas.

hashtag
Snowflake Tags in the Catalog

Snowflake tags are seamlessly integrated into your catalog workflows, providing immediate context for data discovery and governance.

hashtag
Viewing Snowflake Tags

In the Asset Details and Schema Tab, Snowflake tags appear alongside other custom attributes in the unified Attributes column. This gives you a complete view of all metadata attached to your columns at a glance.

hashtag
Catalog Filtering for Discovery

Leverage Snowflake tags to refine your search and locate the exact data assets you need. Use the Filter by Asset Attributes workflow to filter by specific tag keys and values.

circle-exclamation

hashtag
Limitations: Snowflake Tag Updates

Please note that changes to tag definitions in Snowflake may require manual intervention to propagate correctly if they conflict with existing values.

Scenario: If a Snowflake tag is modified from accepting "any text" to only allowing specific enum values (e.g., changing a free-text tag to only accept "High", "Medium", "Low"), existing objects in Snowflake might still retain old values that are now invalid (e.g., "Urgent").

In this case, Decube will follow the new strict enum definition from Snowflake. As a result, the old value ("Urgent") will no longer be displayed in the Catalog because it does not match the valid list of allowed values. To fix this, update the tag value on the Snowflake object to match the new enum definition.

hashtag
Key Benefits

  • Operational Efficiency: Removes the need to duplicate tagging work between Snowflake and Decube.

  • Risk Mitigation: Ensures critical tags like PII and Security classifications are instantly visible in the catalog.

  • Single Source of Truth: Maintains consistency by treating Snowflake as the master record for these specific metadata tags.

PreviousSyncing description from source (BETA)NextApplying custom attributes to catalog assets

Last updated