Using Advanced Search

Stemma’s advanced search helps you quickly narrow your criteria and find the data assets you want to see:

Search bar: The search bar allows you to enter free-form text to search across nearly every piece of metadata in your entire data ecosystem. This includes table names, descriptions, column names, column descriptions and more.

Filtering: You can use the following powerful filters, separately or together, to narrow your search to find the assets you need:

• Resource filtering: allows you to choose what type of resource to return in the search results; options are Tables, Dashboards, and Users. By default, Tables and Dashboards are selected.
• Asset status filtering: filters results to only include the relevant statuses. The options are Certified, No Status, Deprecated, and Intermediate. The default options are Certified and No Status.
• Table filters: these apply only to the Tables results. If you have another resource type besides Tables selected in your resource filter, the values used in the table filters will not affect those other results. Table filters allow you to filter results by the data source, database, schema and table name. You can also filter by column; this will return any table that contains that column name.
• Dashboard filters: these apply only to the Dashboard resource results. If you have another resource types besides Dashboard selected in your resource filter, the value used in the dashboard filters will not affect those other results. Dashboard filters can be used on the product, folder or dashboard name.
• Table & Dashboard filters: These can be applied to both Tables and Dashboards resource types. You can filter both Tables and Dashboards by the tag that is associated with them.

Advanced filtering

By default, all filters look for an exact match for the value you provide. But the Table, Dashboard and Table & Dashboard filters allow for advanced wildcard searches.

To use a wildcard search, you can place one or more asterisks * in the filter box. Here are a few examples:

You can also combine multiple filters together!

For example, you might want to find all tables in the marketing schema that begin with marketing and end with raw–but only tables that include the column order_id.

Understanding the Results

Stemma’s advanced search naturally ranks your search results based on their actual usage. This means the more users run queries on a table the higher the rank that table is likely to have in your search results. In addition, the result list shows you additional reasons why your assets were returned.

This example shows the search results for the search term “orders”:

Points to note:

• Any words in the table or dashboard description that match the search term are highlighted
• Any column names that have an exact match or a similar match are listed to the right
• Any column description that matches the search term is displayed on the right