List of functions supported by each data store

Article summary

Did you find this summary helpful?

Thank you for your feedback!

List of Functions Supported by Data Catalog

The following is a list of features that TROCCO's Data Catalog has.
Some features apply when used in conjunction with TROCCO.

Each function	supplement
Table Column Search
Automatic asset capture function
Automatic metadata acquisition function
Automatic takeover of metadata associated with columns
Summary Statistics and Data Preview	In the case of BigQuery, data may be sampled during query execution.
Manual Column Setting
column lineage
ER diagram
JOIN Analysis
queriedita	Snowflake does not support the following displays. Function Pop Tip Syntax Error Amount of data processed before query execution (result of dry_run execution)
Preview of query execution results
Download CSV of query execution results	Only BigQuery is supported.
Metadata Import
Metadata Transfer (Data Source TROCCO)	Only BigQuery is supported.

List of metadata automatically acquired by the automatic asset capturing function.

item name	sample value
Project	`sample_project`
data-set	`sample_dataset`
table	sample_table
Table Type (TABLE_TYPE)	`BASE TABLE`
INSERT availability (IS_INSERTABLE_INTO)	`TRUE`
Creation date and time (CREATION_TIME)	`2023-01-23 20:11:42 JST`
Clustered table settings	`FALSE`

item name	sample value
database	`TEST_DATABASE`
schema	`TEST_SCHEMA`
Table Type (TABLE_TYPE)	`BASE TABLE`
Roles (TABLE_OWNER)	`TEST_ROLE`
Temporary Tables (IS_TRANSIENT)	`true`
Row Count (ROW_COUNT)	`100`
Bytes (BYTES)	`1KB`
Creation date (CREATED)	`2023-01-01 00:00:00 JST`
Modified date and time (LAST_ALTERED)	`2023-01-01 00:00:00 JST`
Comment (COMMENT)	`comment`
Number of days to retain TimeTravel history data (RETENTION_TIME)	`1`
Automatic clustering setting (AUTO_CLUSTERING_ON)	`true`
Clustering Key (CLUSTERING_KEY)	`LINEAR(COLUMN_NAME)`

Was this article helpful?

Table of contents