Finding data (table/column search)

summary

TROCCO's data catalog allows you to search tables and columns based on metadata as well.
It also supports narrowing down the search target and search range.

search target string

The search will be for strings that are included in one of the following

• Table column name, or the name of each element to which the table belongs

  • Project / Database Name
  • Dataset / Schema Name
  • table name
  • column name

• Basic Metadata

  • logical name
  • Description.

• user defined metadata

  • Input contents of String type field
  • Input contents of Text (Markdown)-type fields

• Related Transfer Settings

  • Name of associated forwarding configuration
  • Related Transfer Settings Memo
• Metadata about the data source

  • Google Analytics Field Display Name
  • Google Analytics Explained
  • kintone application name
  • kintone field name
  • kintone explanation
  • MySQL column name
  • MySQL table name
  • Salesforce object name
  • Salesforce Field Name
  • Salesforce Help Text
  • Salesforce Description
  • Salesforce Japanese column name
  • Japanese display name of search ad field in Yahoo!
  • Search Ads Report Field Name Yahoo!

Search Method

Type the string you want to search in the search bar, click the magnifying glass icon (or press Enter), and the search results will be displayed as shown below.

Refine search results

The above search will search all tables/columns.
Search results can be narrowed down as follows

• Narrowing down the display target
  • By default, all table columns are searched.
  • If you wish to narrow your search, uncheck the boxes as appropriate.
• Narrowing the search range
  • By default, all projects (or databases) are searched.
  • To narrow your search, select a project (or database).
  • When a project (or database) is selected, its lower-level selections are displayed one after the other, allowing you to refine your selections more finely.