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.