---
title: "List of functions supported by each data store"
slug: "datacatalog-supported-functions-list-v1"
updated: 2024-08-15T09:38:44Z
published: 2024-08-15T09:38:44Z
canonical: "documents.trocco.io/datacatalog-supported-functions-list-v1"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documents.trocco.io/llms.txt
> Use this file to discover all available pages before exploring further.

# List of functions supported by each data store

## 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](/docs/metadata-search-function-v1) |  |
| [Automatic asset capture function](/docs/automatic-assets-update-v1) |  |
| [Automatic metadata acquisition function](/docs/automatic-metadata-fetched-v1) |  |
| [Automatic takeover of metadata associated with columns](/docs/automatic-metadata-fetched-v1#%E3%82%AB%E3%83%A9%E3%83%A0%E3%81%AB%E7%B4%90%E3%81%A5%E3%81%8F%E3%83%A1%E3%82%BF%E3%83%87%E3%83%BC%E3%82%BF%E3%81%AE%E8%87%AA%E5%8B%95%E5%BC%95%E3%81%8D%E7%B6%99%E3%81%8E) |  |
| [Summary Statistics and Data Preview](/docs/table-information-v1#%E3%82%AB%E3%83%A9%E3%83%A0%E6%83%85%E5%A0%B1) | In the case of BigQuery, [data may be sampled](/docs/catalog-glossary-v1#%E5%AE%9F%E3%83%87%E3%83%BC%E3%82%BF) during query execution. |
| [Manual Column Setting](/docs/table-information-v1#%E3%82%AB%E3%83%A9%E3%83%A0%E6%83%85%E5%A0%B1) |  |
| [column lineage](/docs/table-information-v1#%E3%82%AB%E3%83%A9%E3%83%A0%E3%83%AA%E3%83%8D%E3%83%BC%E3%82%B8) |  |
| [ER diagram](/docs/erd-and-join-v1) |  |
| [JOIN Analysis](/docs/erd-and-join-v1#join%E5%88%86%E6%9E%90) |  |
| [queriedita](/docs/query-editor-v1) | Snowflake does not support the following displays.Function Pop TipSyntax ErrorAmount of data processed before query execution (result of dry_run execution) |
| [Preview of query execution results](/docs/query-editor-v1) |  |
| [Download CSV of query execution results](/docs/query-editor-v1) | Only BigQuery is supported. |
| [Metadata Import](/docs/data-catalog-settings-v1#%E3%83%A1%E3%82%BF%E3%83%87%E3%83%BC%E3%82%BF%E3%82%A4%E3%83%B3%E3%83%9D%E3%83%BC%E3%83%88) |  |
| [Metadata Transfer (Data Source TROCCO)](/docs/data-source-trocco) | Only BigQuery is supported. |

## Metadata details about the data store

List of metadata automatically acquired by [the automatic asset capturing function](/docs/automatic-assets-update-v1).

### 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)` |