Data Catalog
  • 24 Jan 2023
  • 2 Minutes to read
  • Dark
    Light

Data Catalog

  • Dark
    Light

Article Summary

Note

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.

supplement

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

Data Understanding

Data aggregation and data checking

Other useful functions

Supported Connectors

As of January 2023, the following connectors are supported by TroCCO's Data Catalog.

Datastore

  • Google BigQuery
  • Snowflake
List of functions supported by each datastore

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
Supported versions of Google Analytics

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.

Examples of various data that are treated as actual data
Query execution and billing

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

How to get metadata

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.

Data Catalog Administrator

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.



Was this article helpful?