Searching for Assets - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
First publish date
2007
Last updated
2024-02-07
Published on
2024-02-07T17:21:58.768552
You can search for an asset in your configured connections in these two ways:
  1. By using the Search box in Catalog: It searches the asset in all the tables, columns, and views
  2. By using the Table, Column, or View card in Catalog: It searches the asset in only tables, columns, or views, as clicked.

To search on all the tables, columns, and views:

  1. On the Catalog page, enter the asset you want to search in the Search text box, and press the Enter button.
    The Search page displays Column, Table, and View cards matching the searched asset.
  2. Click Table, Column, or View, to narrow your search.
  3. You can also use the Filter panel on the left side of the page to specify various search criteria.
    Field Details
    Include tags Select the tag applied on the asset. The list displays all the tags applied by you to different assets.
    Note: You can select multiple tags for filtering asset.
    Connection type From the list of configured connection types, select those to which the asset belongs. For example select SQL, Salesforce, or Oracle, if the name table you are searching for is saved in these connections.
    Note: You can select multiple connection types for filtering assets.
    Connection name Name with which the connection related to the asset is saved. For example, an Oracle connection saved with the name OracleDB will have Connection Type as Oracle and Connection Name as OracleDB.
    Note: You can select multiple connection names for filtering the assets.
    Date discovered (on or after) Specify the date on or after which the asset was discovered.
  4. To search for specific tables, columns, or views, use these additional filter criteria:
    Field Description
    Table
    Schema Name of the schema attached to the table you are searching.
    Contains column Name of any column in the table you are searching.
    Note: You can select multiple column names.
    Find related table Select the table to which the table you are looking for is related.
    Note: All the tables related by primary or foreign key to the selected table are displayed.
    Column
    Table Select the table to which the column belongs.
    Note: You can not select multiple tables.
    Data Type Select the data type of the column.
    Semantic type Select the semantic type based on the details contained in the column.
    Note: You can filter based on only one semantic type at a time.
    Key column Specify if the column you are searching for is a primary key.
    Null allowed Specify if the column allows null value.
    View
    Schema Name of the schema attached to the view you are searching.
    Contains column Name of the column in the view.
    The assets matching your search criteria are displayed as cards. You can expand cards by clicking on those. You can also perform these functions on the asset cards:
    • Add or update tag to the asset
    • View profiling details related to the asset
    • Promote the asset as a business glossary entry
    • View the lineage of the asset
      Note: For details on these tasks, see the section Actions on Assets.
  5. To save your search results, click Save Search, and give a name to your search result in the Save Search pop-up window.
    The search result is displayed in the Saved Searches list in the catalog.
    Note: You can also go to the search result page with the URL. Along with the searched assets, the page displays all the filter criteria you applied for the assets.