We've added a few search operators to help locate potentially stale assets quickly.
last_queried_before:YYYY-MM-DD
or last_queried_before:10d
Find dataset assets that were last queried before a certain absolute date or a particular number of days.
last_refreshed_before:YYYY-MM-DD
or last_refreshed_before:10d
Find dataset assets that were last refreshed (i.e. Last time the data in the table or view was changed due to a DML call (e.g. Insert, Update, etc.) ) before a certain absolute date or a particular number of days.
created_before:YYYY-MM-DD
or created_before:10d
Find dataset assets that were created before a certain absolute date or a particular number of days.
These operators can be chained to narrow down the selection.
For example, to find all assets within the acme database that were created a year ago but haven't been queried in the last 30 days - use the query :
database:acme created_before:365d last_queried_before:30d
Note
: created_before
is only supported for Snowflake, Bigquery and Databricks Unity Catalog.