List of functions supported by each data store

Prev Next

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.

    Metadata details about the data store

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

    For BigQuery datastores

    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

    For Snowflake datastores

    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)