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. |
Usage Notes¶
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.