Certify or deprecate an asset
- Open the asset page.
- Click
Marksin the header and selectCertifyorDeprecate. - Optionally, enter a reason. When you deprecate, name the asset to use instead, for example
use analytics.orders_v2 instead. - Click
CertifyorDeprecateto confirm.
Marks and select Remove certification or Remove deprecation. To see every change to the marks of the asset, select See history. The history also shows the marks set on a linked asset, like the dbt model that builds a table.
Who can set a mark
Read more about owners and user roles.
See all certified and deprecated assets
Go to . Next to the context entries, the page has three tabs for the marks.Certified and deprecatedlists the certified or the deprecated assets. TheCertified/Deprecatedswitch picks the mark, andBy meshows only the marks you set. The catalog filters narrow the list. An asset that the deprecation query selects showsDeprecation queryin theBycolumn.Mark historylists every change to a mark in the workspace, newest first, with who made it, when and why. Changes to the deprecation query are listed too.Deprecation queryholds the query that deprecates assets in bulk, described below.
Deprecate assets with a query
A workspace can have one deprecation query. Every asset that matches the query is deprecated, including assets that appear after you save it. Use it to deprecate a whole legacy schema, or every table that carries a label in your warehouse.- Go to .
- Select the assets with the filters: Browser, Name search, Type, Platform, Annotation, Product or a ResolverQL query. The page shows the number of matching assets and the list of them, so you can check the selection before you save it.
- Optionally, enter a reason. The reason shows on every asset that matches.
- Click
Save changes.
Deprecated by the workspace query, with a link to the query. You cannot remove this deprecation from the asset page, only by changing the query.
You cannot save a query that uses with_mark(...), also when it reaches with_mark(...) through an owner or a data product that it selects.
Deprecate by a warehouse label
If your team already tags legacy tables in the warehouse, you can deprecate them by that tag. Table tags and labels arrive in Coalesce Quality as annotations, and the deprecation query can select by annotation.
For example, a Snowflake tag
DWH_TESTING.GOVERNANCE.LIFECYCLE set to 'legacy' on a table becomes the annotation snowflake.dwh_testing.governance.lifecycle with the value legacy.
- Open the deprecation query.
- Add an
Annotationfilter onsnowflake.dwh_testing.governance.lifecyclewith the valuelegacy. - Enter a reason, for example
Tagged as legacy in Snowflake, and clickSave changes.
Filter the Catalog by mark
On the page, clickAdd filter, select Mark, then Certified, Deprecated or both. Change is to is not to hide the marked assets, for example to list every revenue table that is not deprecated. The filter also matches the assets certified or deprecated in Coalesce Catalog.
In a ResolverQL query, the same filter is with_mark(kind="certified") or with_mark(kind="deprecated").
Stop monitoring deprecated assets
A deprecated table usually does not need monitors. To keep the deprecated assets out of all deployment rules, add an exclusion rule with this ResolverQL query:Certified semantic models
Several semantic models can define a metric with the same name. On the page of such a metric, Coalesce Quality names the definition to use only if all of these are true:- Exactly one of the models is certified.
- The definition of that model did not change after it was certified.
- That model is not deprecated.
Certification outdated, and the model no longer counts as certified. A change to a description or a display name does not count. To confirm that the new definition is still the one to use, click Marks and select Certify again.
AI assistants and the API
The Coalesce Quality MCP server has tools to read, list, set and remove marks.get_metric_definitions uses the marks to name the definition of a metric to use. No MCP tool changes the deprecation query.
In the API, synq.entities.marks.v1alpha.EntityMarksService reads and sets the marks and the deprecation query. Setting marks needs SCOPE_ENTITY_MARKS_EDIT, or SCOPE_ENTITY_MARKS_OWNED_EDIT for the assets you own. See the API reference and API scopes. This API is in alpha, and its shape can change.