HYBRID_TABLES View¶

This Account Usage view displays a row for each hybrid table defined in the specified (or current) database.

Columns¶

Column Name	Data Type	Description
ID	NUMBER	ID of the hybrid table.
NAME	TEXT	Name of the hybrid table.
SCHEMA_ID	NUMBER	ID of the schema to which the hybrid table belongs.
SCHEMA_NAME	TEXT	Schema to which the hybrid table belongs.
DATABASE_ID	NUMBER	ID of the database to which the hybrid table belongs.
DATABASE_NAME	TEXT	Database to which the hybrid table belongs.
OWNER	TEXT	Owner of the hybrid table.
ROW_COUNT	NUMBER	Approximate row count of the hybrid table.
BYTES	NUMBER	Approximate size in bytes of the row store of the hybrid table.
RETENTION_TIME	NUMBER	Retention time for data in the hybrid table.
CREATED	TIMESTAMP_LTZ	Creation time of the hybrid table.
LAST_ALTERED	TIMESTAMP_LTZ	Last time this hybrid table was altered by a DDL, a truncate or insert_overwrite, or a compaction job. Note that this does not include regular DMLs.
DELETED	TIMESTAMP_LTZ	Date and time when the hybrid table was dropped.
COMMENT	TEXT	Comment for the hybrid table.
OWNER_ROLE_TYPE	TEXT	The type of role that owns the object, either `ROLE` or `DATABASE_ROLE`. . If a Snowflake Native App owns the object, the value is `APPLICATION`. . Snowflake returns NULL if you delete the object because a deleted object does not have an owner role.

Latency for the view may be up to 180 minutes (3 hours).