HYBRID_TABLES view¶

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

Columns¶

Column Name	Data Type	Description
CATALOG	TEXT	Database to which the hybrid table belongs.
SCHEMA	TEXT	Schema to which the hybrd table belongs.
NAME	TEXT	Name of the hybrid table.
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	The 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.
COMMENT	TEXT	Comment for the hybrid table.

The view only displays objects for which the current role for the session has been granted access privileges. The view does not honor the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command when both are executed with a role that was granted the MANAGE GRANTS privilege.
Just as with SHOW TABLES and SHOW HYBRID TABLES, the bytes and row count are approximate.