List of Supported Features for each Data Warehouse
  • 20 Jan 2023
  • 1 Minute to read
  • Dark
    Light

List of Supported Features for each Data Warehouse

  • Dark
    Light

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.

List of functions supported by data store

Each function of Trocco's data catalog may not be supported depending on the data store.

BigQuerySnowflakeSupplement
Metadata search function
Catalog data extraction functionThe ability to retrieve metadata from a data store.
Automatic metadata integrationThis is a function that retrieves metadata from a data source.
Summary statistics and data previewSnowflake does not perform sampling.
Defining column references manually
Column lineage-Not supported by Snowflake.
Automatic transfer of metadata associated with columns-Not supported by Snowflake.
ER diagram
JOIN Analysis
Query Editor✓(*)Snowflake does not support the following displays:
  • Function ScreenTip
  • Syntax Error
  • Amount of data processed before query execution (dry_run execution result)
Preview query execution results
CSV download of query execution results-Not supported by Snowflake.
Trocco basic metadata settings
Templates for user-defined metadata
Metadata Import
Metadata transfer (source trocco)-Not supported by Snowflake.

List of metadata to be retrieved

For BigQuery

Sample valueof item name
projectsample_project
Datasetsample_dataset
tablesample_table
Table Type (TABLE_TYPE)BASE TABLE
INSERT Possibility (IS_INSERTABLE_INTO)TRUE
Created (CREATION_TIME)2023-01-23 20:11:42 JST
Clustered table settingsFALSE

For Snowflake

Sample valueof item name
databaseTEST_DATABASE
schemaTEST_SCHEMA
Table Type (TABLE_TYPE)BASE TABLE
Roles (TABLE_OWNER)TEST_ROLE
Temporary tables (IS_TRANSIENT)true
Number of rows (ROW_COUNT)100
BYTES1KB
Created (TABLE_OWNER)2023-01-01 00:00:00 JST
Modified (LAST_ALTERED)2023-01-01 00:00:00 JST
COMMENT (COMMENT)comment
Days to retain TimeTravel historical data (RETENTION_TIME)1
Configuring Automatic Clustering (AUTO_CLUSTERING_ON)true
Clustering Key (CLUSTERING_KEY)LINEAR(COLUMN_NAME)

Was this article helpful?

What's Next