## Use filters menu

URL: https://docs.atlan.com/product/capabilities/discovery/how-tos/use-the-filters-menu

> You can refine the search for your assets in Atlan using the filters menu. Add filters to your asset search to find assets that are more relevant to you.

You can refine the search for your assets in Atlan using the filters menu. Add filters to your asset search to find assets that are more relevant to you.

Once you have added filters, you can also:

- Bookmark your search results with applied filters for quick access.
- Copy the browser URL with applied filters and share it with other users in your organization - they may need to log into Atlan first to view the search results.
- [Export filtered assets to spreadsheets](https://docs.atlan.com/llms/governance/integrations/export-assets/llms.txt) and enrich asset metadata in bulk.

:::info **Did you know?** 
 You can resize the filters panel. Hover over the edge of the panel and then click and drag the slider arrow to resize it. Atlan will remember your preferred size for the duration of your session. The panel will be returned to the default size when you log in again.

:::

Use the following filters to help with asset discovery. Start by either clicking on all assets or the search bar from any screen in Atlan:

* If you are using the **Old UI (Classic)**, click **Assets** in the left panel.

## Source

You can use [source-specific](https://docs.atlan.com/llms/catalog/connector-capabilities/supported-sources/llms.txt) filters to curate a list of relevant assets to search from.

To filter by a specific source:

1. In the _Filters_ menu on the left, click **Source**.
2. Click **Choose connection** to filter by a [supported connector](https://docs.atlan.com/llms/catalog/connector-capabilities/supported-sources/llms.txt).
3. (Optional) Select an existing connection for a selected connector:
 1. Click **All Databases** to filter by databases for a selected connection.
 2. Click **All Schemas** to filter by schemas for a selected connection.

## Asset type

You can filter your search results by specific types of assets. The asset type filter also includes a quick count of all the resulting assets grouped by type. You can select multiple asset types to group search results by asset types.

For example, if you would only like to view column assets:

1. Under the search bar on the _Assets_ page, click the **Asset type** dropdown.
2. From the _Asset type_ dropdown, click the **Column** tab to only view column assets. Only column assets will be displayed in the results, with the tab showing a total count of the column assets.
3. (Optional) In the _Filters_ menu on the left, under _Asset Type Filters_, click **Column** to add a type-specific property filter to further refine your search:
 - Click **Parent asset type** to filter columns by a parent asset type - tables and views.
 - Click **Parent asset name** to filter columns by the name of a table or view, or set a matching condition such as pattern match.
 - Click **Data type** to filter columns by data types.
 - Click any of the [column keys](https://docs.atlan.com/llms/catalog/connector-capabilities/column-keys-crawled/llms.txt) to filter by column keys.
4. (Optional) If an asset type you're filtering for does not match the search keywords but there are other asset types that match, click **Check other matches** to view those assets or click **Clear search** to clear your search and start over.

## Domains

[Domains](https://docs.atlan.com/llms/governance/domains/manage-domains/llms.txt) provide a logical way of mapping and organizing assets within a specific domain or business entity. You can filter assets by a single domain, multiple domains, or no domains.

To filter assets by domains:

1. In the _Filters_ menu on the left, click **Domains** to expand the menu.
2. Under _Domains_, to filter assets by domains:
 - Check the boxes to select one or more domains or subdomains to filter your assets.
 - Click **No domains** to filter assets not mapped to any domain.

## Metadata filters

### Certificate

You can filter your asset search based on the [certificate](https://docs.atlan.com/llms/catalog/discovery/add-certificates/llms.txt) attached to the data assets - _Verified_, _Draft_, _Deprecated_, and _No certificate_.

For example, if you would only like to view verified assets:

1. In the _Filters_ menu on the left, click **Certificate** to expand the menu.
2. Under _Certificate_, click **Verified** to only view verified assets in your search results. 

### Owners

You can filter your asset search by selecting one or more [owners](https://docs.atlan.com/llms/catalog/discovery/add-owners/llms.txt). You can also toggle between individual users and groups to filter results based on a group of users. Or, select _No Owners_ in the owners filter to view assets that currently do not have any owners and assign them if needed.

For example, if you would like to filter assets by a group of owners:

1. In the _Filters_ menu on the left, click **Owners** to expand the menu.
2. Under _Owners_, click the **group** **icon**.
3. Click the group name by which you want to filter your assets.

### Tags

You can filter your assets by user-generated [tags](https://docs.atlan.com/llms/governance/tags/what-are-tags/llms.txt), such as `public`, `PII`, and more. You can also select _No Tag_ in the tags filter to view assets that currently do not have any tags and add them if needed.

For example, if you would like to filter assets for a data compliance check:

1. In the _Filters_ menu on the left, click **Tags** to expand the menu.
2. Under _Tags_, click the relevant option - for example, `PII`.
3. (Optional) Filter for assets by tags imported from supported sources:
 - Select a [synced Snowflake tag](https://docs.atlan.com/llms/connectors/snowflake/manage-snowflake-tags/llms.txt) to view tagged Snowflake assets only.
 1. To filter by Snowflake tag values, next to the tag name, click the rightward arrow to open the tag value menu.
 2. In the _Filter by tag value_ dialog, click the **Select tag value** dropdown and then select a tag value to filter assets. You can either search by predefined [allowed values](https://docs.snowflake.com/en/user-guide/object-tagging#specify-tag-values) or tag values.
 - Select a [synced dbt tag](https://docs.atlan.com/llms/connectors/dbt/manage-dbt-tags/llms.txt) to view tagged dbt Cloud or dbt Core assets only.
 - Select a [synced Databricks tag](https://docs.atlan.com/llms/connectors/databricks/manage-databricks-tags/llms.txt) to view tagged Databricks assets only. You can also filter by Databricks tag values.

### Terms

You can filter your asset search by terms from your [glossaries](https://docs.atlan.com/llms/governance/glossary/set-up-glossaries/llms.txt). You can also select _No Terms_ in the terms filter to view assets that currently do not have any linked terms and add them if needed.

For example, if you would like find assets linked to a specific term:

1. In the _Filters_ menu on the left, click **Terms** to expand the menu.
2. Under _Terms_, click the relevant term - for example, `Marketing Analysis` - to discover assets linked to that term.
3. (Optional) Next to the search bar in the _Terms_ filter, click the **Advanced options** icon to set a matching condition. Click the operators dropdown, and then:
 - Click **Or** to filter assets that match any selected term(s).
 - Click **And** to filter assets that match all selected terms.
 - Click **None of** to filter assets that do not match any of the selected term(s).
 - Click **Not empty** to filter assets that have one or more [linked terms](https://docs.atlan.com/llms/governance/glossary/link-terms-to-assets/llms.txt).
 - Click **Empty** to filter assets without any [linked terms](https://docs.atlan.com/llms/governance/glossary/link-terms-to-assets/llms.txt).

### Properties

Properties offer a variety of filters to narrow down your asset search. You can filter your assets by common asset properties, such as name, description, last updated, and more. 

To search by common asset properties:

1. In the _Filters_ menu on the left, click **Properties** to expand the menu.
2. From the _Properties_ menu, you can:
 - Click **Title** to search by the technical name or [alias](https://docs.atlan.com/llms/catalog/discovery/add-an-alias/llms.txt) of an asset. From the dialog, set your preferred matching condition (see _Description_ filter).
 - Click **Description** to search by the description of an asset in Atlan or from the source. To set a matching condition, from the _Description_ dialog, click the operators dropdown to:
 - Click **Equals (=)** or **Not Equals (!=)** to include or exclude assets through exact match search.
 - Click **Starts With** or **Ends With** to filter assets using the starting or ending sequence of values.
 - Click **Contains** to find assets with specified values contained within the property.
 - Click **Pattern** to filter assets using supported [Elastic DSL regular expressions](https://www.elastic.co/guide/en/elasticsearch/references/current/regexp-syntax.html).
 - Click **Is Empty** or **Is Not Empty** to filter assets with or without null values.
 - Click **Starred assets** to filter for all your [starred assets](https://docs.atlan.com/llms/catalog/discovery/star-assets/llms.txt).
 - Click **Has lineage** to filter for assets with or without [data lineage](https://docs.atlan.com/llms/catalog/lineage/what-is-lineage/llms.txt).
 - Click **Has readme** to filter for assets with or without [README files](https://docs.atlan.com/llms/governance/integrations/llms.txt).
 - Click **Has resources** to filter for assets with or without [resources](https://docs.atlan.com/llms/catalog/discovery/add-a-resource/llms.txt).
 - Click **Announcement** to find assets with a specific [announcement](https://docs.atlan.com/llms/governance/integrations/create-announcements/llms.txt) type. From the _Announcement_ dialog, click the dropdown menu to select _Information_, _Issue_, _Warning_, or _No announcement_.
 - Click **Unique identifier** to find assets with a unique ID. From the dialog, select your preferred matching condition and type the relevant information.
 - Click **Qualified name** to filter by a unique name for the asset. From the dialog, select your preferred matching condition and type the relevant information (see _Description_ filter).
 - Click **Last updated (in source)** or **Last updated (in Atlan)** to find assets by when they were last updated and where. From the dialog, set the condition to _Before_ or _After_ and then select a date.
 - Click **Created (in source)** or **Created (in Atlan)** to find assets by when they were created and where. From the dialog, set the condition to _Before_ or _After_ and then select a date.
 - Click **Created by (Atlan)** or **Last updated by** **(Atlan)** to filter assets by a user who created or last updated the asset in Atlan. From the dialog, from the _Select user_ dropdown, select the user name.
 - Click **Is archived** to view [archived assets](https://docs.atlan.com/llms/catalog/discovery/access-archived-assets/llms.txt) in the search results.
3. (Optional) Click the **+** sign to add more filtering options - currently only available with the _Title_, _Description_, _Unique identifier_, _Qualified name_, _Last updated_ (in source and Atlan), and _Created_ (in source and Atlan) filters.

### dbt

:::warning

The dbt filters will only appear in the filters menu if [dbt assets have been crawled](https://docs.atlan.com/llms/connectors/dbt/crawl-dbt/llms.txt).

:::

The dbt filters allow you to filter your [dbt Cloud](https://docs.atlan.com/llms/connectors/dbt/what-does-atlan-crawl-from-dbt-cloud/llms.txt) and [dbt Core](https://docs.atlan.com/llms/connectors/dbt/what-does-atlan-crawl-from-dbt-core/llms.txt) assets to find the most relevant results. For example, if you need to find assets from a specific project in dbt:

1. In the _Filters_ menu on the left, click **dbt** to expand the menu.
2. Under _dbt_, click **Project name** to filter by a specific project.
3. In the _Project name_ dialog:
 1. Select the relevant matching condition.
 2. For _Type_, type the project name to filter your assets - for example, `food-beverage`.
4. (Optional) Click the **+** sign to add more filtering options. (Note: This may not be available for all the dbt filters).

### Usage

The usage filters allow you to [filter your assets by usage](https://docs.atlan.com/llms/catalog/usage-and-popularity/find-assets-by-usage/llms.txt) metadata. For example, you can:

- Filter assets with zero queries and archive them.
- Find costly assets to better optimize your operations.
- Discover recently updated assets and follow up on the updates. 

## Custom metadata filters

:::warning

You first need to set up custom metadata properties and toggle on the _Show in filter_ slider during setup.

:::

When you [add custom metadata](https://docs.atlan.com/llms/governance/custom-metadata/what-is-custom-metadata/llms.txt) in Atlan, you can also choose to set custom metadata properties as filters to help with quicker asset discovery.

For example, if you would like to filter your assets by custom user roles metadata:

1. In the _Filters_ menu on the left, click the custom metadata filter - for example, `Stewards`.
2. Under the custom metadata filter, select the custom metadata property - such as `Data Steward`.
3. In the property dialog, select the matching condition and user to filter your assets.
4. (Optional) For [custom metadata option properties](https://docs.atlan.com/llms/governance/custom-metadata/manage-custom-metadata-structures/llms.txt) only:
 1. You can either:
 - For custom metadata properties with five or fewer options, click the operators dropdown.
 - For custom metadata properties with more than five options, next to the search bar, click the **Advanced options** icon and then click the operators dropdown.
 2. From the operators dropdown, you can:
 - Click **Or** to filter assets that match any selected value(s).
 - Click **And** to filter assets that match all selected values - only supported if [multiple values are allowed](https://docs.atlan.com/llms/governance/custom-metadata/manage-custom-metadata-structures/llms.txt) for custom metadata options.
 - Click **None of** to filter assets that do not match any of the selected value(s) - only supported if [multiple values are allowed](https://docs.atlan.com/llms/governance/custom-metadata/manage-custom-metadata-structures/llms.txt) for custom metadata options.
 - Click **Not empty** to filter assets that have one or more assigned values for the selected property.
 - Click **Empty** to filter assets without any assigned values for the selected property.

## Asset type filters

You can choose from two different sets of filters - type-specific or connector-specific.

### Type-specific filters

If you're [filtering by a specific asset type](#asset-type), you can select type-specific property filters to further refine your search. For example, if you're filtering by:

- Tables or views - you can filter these asset types by a specific row or column count.
- Columns - you can filter column assets by parent asset type and name, data type, or [column keys](https://docs.atlan.com/llms/catalog/connector-capabilities/column-keys-crawled/llms.txt).
- Process - you can filter [process assets](https://docs.atlan.com/llms/catalog/lineage/what-are-processes/llms.txt) by the SQL query.
- Query - you can filter saved queries by [visual queries](https://docs.atlan.com/llms/catalog/insights/query-data/llms.txt).

### Connector-specific filters

Connector-specific filters will appear in the filters menu only if there are crawled assets for a supported source and asset-type filters specific to the connector are applied.

Connector-specific filters are currently supported for the following sources:

- [Anomalo](https://docs.atlan.com/llms/connectors/anomalo/what-does-atlan-crawl-from-anomalo/llms.txt)
- [Apache Kafka](https://docs.atlan.com/llms/connectors/apache-kafka/what-does-atlan-crawl-from-apache-kafka/llms.txt), [Confluent Kafka](https://docs.atlan.com/llms/connectors/confluent-kafka/what-does-atlan-crawl-from-confluent-kafka/llms.txt), [Aiven Kafka](https://docs.atlan.com/llms/connectors/aiven-kafka/what-does-atlan-crawl-from-aiven-kafka/llms.txt), [Redpanda Kafka](https://docs.atlan.com/llms/connectors/redpanda-kafka/what-does-atlan-crawl-from-redpanda-kafka/llms.txt), and [Amazon MSK](https://docs.atlan.com/llms/connectors/amazon-msk/what-does-atlan-crawl-from-amazon-msk/llms.txt)
- [Apache Airflow/OpenLineage](https://docs.atlan.com/llms/connectors/apache-airflow-openlineage/what-does-atlan-crawl-from-apache-airflow-openlineage/llms.txt), [Amazon MWAA](https://docs.atlan.com/llms/connectors/amazon-mwaa-openlineage/what-does-atlan-crawl-from-amazon-mwaa-openlineage/llms.txt), [Astronomer](https://docs.atlan.com/llms/connectors/astronomer-openlineage/what-does-atlan-crawl-from-astronomer-openlineage/llms.txt), [Google Cloud Composer](https://docs.atlan.com/llms/connectors/google-cloud-composer-openlineage/what-does-atlan-crawl-from-google-cloud-composer-openlineage/llms.txt), and [Apache Spark](https://docs.atlan.com/llms/connectors/apache-spark-openlineage/what-does-atlan-crawl-from-apache-spark-openlineage/llms.txt)
- [Google BigQuery](https://docs.atlan.com/llms/connectors/google-bigquery/what-does-atlan-crawl-from-google-bigquery/llms.txt)
- [Matillion](https://docs.atlan.com/llms/connectors/matillion/what-does-atlan-crawl-from-matillion/llms.txt)
- [Microsoft Azure Cosmos DB](https://docs.atlan.com/llms/connectors/microsoft-azure-cosmos-db/what-does-atlan-crawl-from-microsoft-azure-cosmos-db/llms.txt)
- [Microsoft Azure Event Hubs](https://docs.atlan.com/llms/connectors/microsoft-azure-event-hubs/what-does-atlan-crawl-from-microsoft-azure-event-hubs/llms.txt)
- [Microsoft Power BI](https://docs.atlan.com/llms/connectors/microsoft-power-bi/what-does-atlan-crawl-from-microsoft-power-bi/llms.txt)
- [MicroStrategy](https://docs.atlan.com/llms/connectors/microstrategy/what-does-atlan-crawl-from-microstrategy/llms.txt)
- [MongoDB](https://docs.atlan.com/llms/connectors/mongodb/what-does-atlan-crawl-from-mongodb/llms.txt)
- [Monte Carlo](https://docs.atlan.com/llms/connectors/monte-carlo/what-does-atlan-crawl-from-monte-carlo/llms.txt)
- [Redash](https://docs.atlan.com/llms/connectors/redash/what-does-atlan-crawl-from-redash/llms.txt)
- [Salesforce](https://docs.atlan.com/llms/connectors/salesforce/what-does-atlan-crawl-from-salesforce/llms.txt)
- [Sisense](https://docs.atlan.com/llms/connectors/sisense/what-does-atlan-crawl-from-sisense/llms.txt)
- [Snowflake](https://docs.atlan.com/llms/connectors/snowflake/what-does-atlan-crawl-from-snowflake/llms.txt)
- [Soda](https://docs.atlan.com/llms/connectors/soda/what-does-atlan-crawl-from-soda/llms.txt)
- [Tableau](https://docs.atlan.com/llms/connectors/tableau/what-does-atlan-crawl-from-tableau/llms.txt)
- [ThoughtSpot](https://docs.atlan.com/llms/connectors/thoughtspot/what-does-atlan-crawl-from-thoughtspot/llms.txt)
- [Qlik Sense Cloud](https://docs.atlan.com/llms/connectors/qlik-sense-cloud/what-does-atlan-crawl-from-qlik-sense-cloud/llms.txt) and [Qlik Sense Enterprise on Windows](https://docs.atlan.com/llms/connectors/qlik-sense-enterprise-on-windows/what-does-atlan-crawl-from-qlik-sense-enterprise-on-windows/llms.txt)
- [Google Cloud Storage](https://docs.atlan.com/llms/connectors/google-gcs/manage-assets/llms.txt) buckets and objects
- [Microsoft Azure Data Lake Storage](https://docs.atlan.com/llms/platform/python/manage-assets/llms.txt) accounts, containers, and objects
- [Preset](https://docs.atlan.com/llms/platform/python/manage-assets/llms.txt) datasets, dashboards, and workspaces
- [API](https://docs.atlan.com/llms/platform/python/manage-assets/llms.txt) paths
- [Files](https://docs.atlan.com/llms/platform/python/manage-assets/llms.txt) - supported file types include DOC, Excel, PPT, CSV, TXT, JSON, XML, and ZIP files

To use a connector-specific filter:

1. From the _Assets_ page, click the **Asset type** filter, and then from the dropdown, select an asset type from a supported connector - in this example, we'll select Soda _Checks_.
2. In the _Filters_ menu on the left, click the **Soda** filter to expand the menu.
3. From the _Soda_ filter menu, filter your Soda checks by check status, owner, or last scanned at date.
4. (Optional) For properties that allow selecting multiple values, you can set your preferred matching condition. Click the operators dropdown and then:
 - Click **Or** to filter assets that match any selected value(s).
 - Click **And** to filter assets that match all selected values.
 - Click **None of** to filter assets that do not match any selected value(s).
 - Click **Not empty** to filter assets that have one or more assigned values for the selected property.
 - Click **Empty** to filter assets without any assigned values for the selected property.

---