- 24 Jan 2023
- 2 Minutes to read
-
Print
-
DarkLight
Data Catalog
- Updated on 24 Jan 2023
- 2 Minutes to read
-
Print
-
DarkLight
This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.
This is a help page about the Data Catalog.
The data catalog is a paid option.
To do so, please contact your sales representative or Customer Success.
summary
At TROCCO, you can create a data catalog by assigning metadata, statistics, etc. to all data that exists in your data analysis infrastructure.
Data Catalog makes it easy to search and browse data.
TROCCO's data catalog strongly supports the resolution of various issues in data analysis operations, such as "I don't know what data is where" and "What kind of information is contained in this data?"
Functions
For details on each function of TROCCO's data catalog, please refer to the linked articles.
Data selection
- Metadata-based search (metadata search function)
- Automatic generation of ER diagrams (ER diagrams)
Data Understanding
- Edit and view metadata (table information)
- Automatic Column Lineage Generation (Column Lineage)
Data aggregation and data checking
- JOIN Analysis (JOIN Analysis)
- Query Editor (Query Editor)
Other useful functions
- Metadata Import (Metadata Import)
- Transferring metadata (from - trocco)
Supported Connectors
As of January 2023, the following connectors are supported by TroCCO's Data Catalog.
Datastore
- Google BigQuery
- Snowflake
Some data stores do not support some features.
For details on the list of functions supported by each data store, refer to the list of functions supported by each data store.
Data Sources
- Google Analytics
- kintone
- MySQL
- PostgreSQL
- Salesforce
- Yahoo! Search Ads
Only UA (Universal Analytics) is supported.
GA4 (Google Analytics 4) is not supported.
Permissions
Access to real data
TROCCO's Data Catalog defines the following values as actual data:
- Values in tables
- Various data generated by querying the table
Of these, only data that the data store allows access to the account used for account authentication can be viewed.
- Summary statistics and data preview of column information
- preview
- JOIN key for JOIN analysis, number of rows linked to Venn diagram, table to be generated
- Query execution results in the Query Editor
The above "various data that is treated as actual data" is displayed by executing a query on the data store managed by the customer.
Therefore, you will be billed for your datastore based on the query execution size. Thank you for your understanding.
Permissions for access to metadata
If you are a Data Catalog user, you can view all automatically retrieved and manually defined metadata.
Metadata retrieval specifications
Trocco's Data Catalog automatically retrieves metadata from customer-managed data stores and data sources.
Every day at around 10 p.m., connect to your data store and data source using the connection information on Trocco to which the data catalog administrator has access and retrieve data.
If the Data Catalog administrator does not have access to the connection information of TROCCO, the metadata cannot be retrieved.
For each data store in the Data Catalog, define the first user in your Troccco account as a Data Catalog administrator.
You can check the user name of the Data Catalog administrator in Data Store Integration Management in Data Catalog settings.