Snowflake · Schema
EventTable
A Snowflake event table
Data LakesData SharingData WarehousingDatabaseSQL
Properties
| Name | Type | Description |
|---|---|---|
| name | string | Name of the event table |
| cluster_by | array | Cluster key column(s) or expression |
| data_retention_time_in_days | integer | number of days to retain the old version of deleted/updated data |
| max_data_extension_time_in_days | integer | Maximum number of days to extend data retention beyond the retention period to prevent a stream becoming stale. |
| change_tracking | boolean | True if change tracking is enabled, allowing streams and CHANGES to be used on the entity. |
| default_ddl_collation | string | Collation that is used for all the new columns created by the DDL statements (if not specified) |
| comment | string | user comment associated to an object in the dictionary |
| created_on | string | Date and time when the event table was created. |
| database_name | string | Database in which the event table is stored |
| schema_name | string | Schema in which the event table is stored |
| owner | string | Role that owns the event table |
| owner_role_type | string | The type of role that owns the event table |
| rows | integer | Number of rows in the table. |
| bytes | integer | Number of bytes that will be scanned if the entire table is scanned in a query.Note that this number may be different than the number of actual physical bytes stored on-disk for the table |
| automatic_clustering | boolean | If Automatic Clustering is enabled for your account, specifies whether it is explicitly enabled or disabled for the table. |
| search_optimization | boolean | If ON, the table has the search optimization service enabled |
| search_optimization_progress | integer | Percentage of the table that has been optimized for search |
| search_optimization_bytes | integer | Number of additional bytes of storage that the search optimization service consumes for this table |
| columns | array |