Skip to content
English
  • There are no suggestions because the search field is empty.

Data Catalog Overview

 The Data Catalog holds table and column metadata for each data source and records changes to it. You can run statistics, add tags and descriptions, and search across metadata and data values.

In the new UI, catalog features are in two places:

  • The Metadata view of a data source, for statistics, tags, descriptions and change history.
  • Search Metadata in Data Explorer, for searching by tag, metadata or content.

      You can also reach the Data Catalog from the command line or through a direct connection, so you can use it from your workflow tools.

      Open the Metadata View

      1. In Data Explorer, expand Database (or File Source & API / Lakehouse).
      2. Select a data source. It opens in a new tab.
      3. In the toolbar, select Metadata.
      4. Select Add tag… in the table row.
      5. Type the tag name, or pick an existing tag, and press Enter.
      6. To remove a tag, select the × on the tag.
      7. Hover over the row and select the pencil icon at the end of the row.
      8. Type the description and press Enter.

             

            The Metadata view has four sections: Update Cycle, Table Metadata, Columns of <table> and Metadata History.

            Update Cycle

            Sets how often the catalog checks the source for metadata changes. Choose Monthly, Weekly, Daily or Hourly.

            Table Metadata

            Lists every table in the data source with the following columns:

            Column

            What it shows

            Table Name

            Name of the table. Select a row to see its columns.

            Record Counts

            Number of rows

            Size in Bytes

            Table size

            Statistics

            Date and time statistics were last run, and the run button

            Index

            Index status, and the button to index the table for content search

            Tags

            Tags on the table

            Description

            Table description

             

            Run table statistics

            Select the run icon (▷) in the Statistics column. Record count, size and the date update when the job completes.

            Index a table

            Select the Run Index icon in the Index column. The table's values can then be found with By contents search.

            Add or remove a tag

                  Add a description

                      Column Metadata

                      Select a table row in Table Metadata. The Columns of <table> section opens below with each column's type, statistics, tags and description.

                      Run column statistics

                      Select the run icon (▷) on the column row. The Statistics column then shows:

                      • Card: cardinality (number of distinct values)
                      • Min and Max: string length for text columns, or the value for numeric columns

                           

                           

                           

                          Metadata History

                          Shows changes to the data source, its tables and columns, with a timestamp. Select the refresh icon to load the latest changes.

                          Column

                          What it shows

                          Change On

                          Date and time of the change

                          Entity

                          What changed, for example DATASOURCE or TABLE

                          Operation

                          Type of change, for example INITIALIZE or ADD

                          Description

                          Details of the change

                           

                           

                           

                          Search Metadata

                          In Data Explorer, select the Search Metadata icon next to the search box. A Search Metadata tab opens with three search options.

                          By tag

                          Select one or more tags, or type to filter the tag list. Results show the Type, Name, Database and Tags for each matching table or column.

                           

                          By metadata

                          Search table names, column names, tags and descriptions. Use * as a wildcard.

                           

                          By contents

                          Search for values stored inside tables. Use * as a wildcard.

                          Note: Only indexed tables are searched. Run the index from the Index column in Table Metadata, or select Build index on the search page.

                           

                           

                          Where to Find Old UI Features

                          Old UI

                          New UI

                          Table Metadata tab

                          Data source > Metadata > Table Metadata and Columns of <table>

                          Metadata Change History tab

                          Data source > Metadata > Update Cycle and Metadata History

                          Metadata Search tab

                          Data Explorer > Search Metadata > By metadata / By contents

                          Tags tab

                          Data Explorer > Search Metadata > By tag