List of Supported Features for each Data Warehouse
- 20 Jan 2023
- Print
- DarkLight
- PDF
List of Supported Features for each Data Warehouse
- Updated on 20 Jan 2023
- Print
- DarkLight
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
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.
| BigQuery | Snowflake | Supplement | |
|---|---|---|---|
| Metadata search function | ✓ | ✓ | |
| Catalog data extraction function | ✓ | ✓ | The ability to retrieve metadata from a data store. |
| Automatic metadata integration | ✓ | ✓ | This is a function that retrieves metadata from a data source. |
| Summary statistics and data preview | ✓ | ✓ | Snowflake 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:
|
| 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 value | of item name |
|---|---|
| project | sample_project |
| Dataset | sample_dataset |
| table | sample_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 settings | FALSE |
For Snowflake
| Sample value | of item name |
|---|---|
| database | TEST_DATABASE |
| schema | TEST_SCHEMA |
| Table Type (TABLE_TYPE) | BASE TABLE |
| Roles (TABLE_OWNER) | TEST_ROLE |
| Temporary tables (IS_TRANSIENT) | true |
| Number of rows (ROW_COUNT) | 100 |
| BYTES | 1KB |
| 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?