Snowflake information_schema - Firebolt Documentation

Under dialect=snowflake, a supported information_schema view follows Snowflake’s INFORMATION_SCHEMA: its column names and order.

Supported views

information_schema.tables (Snowflake reference).
information_schema.columns (Snowflake reference).
information_schema.views (Snowflake reference).
information_schema.schemata (Snowflake reference).
information_schema.databases (Snowflake reference).

Any INFORMATION_SCHEMA view not listed does not exist in Snowflake mode: querying it raises a “relation does not exist” error.

Addressing

Snowflake’s INFORMATION_SCHEMA is scoped to one database, with no dataset or region qualifier:

INFORMATION_SCHEMA.TABLES: the current database.
<database>.INFORMATION_SCHEMA.TABLES: the named database.

Notes

Values carry Firebolt conventions, not Snowflake’s: columns.data_type returns Firebolt type names (NUMBER, TEXT), views.view_definition and tables.last_ddl return Firebolt DDL, and identifier values (schema, table, and column names) are lower-case rather than upper-cased.
Snowflake columns with no Firebolt source are NULL (for example tables.is_transient, tables.retention_time, and the object-kind flags such as tables.is_iceberg).
A view cannot be created over a Snowflake-shaped information_schema view: the stored definition could not be re-resolved outside the dialect. Query it directly, or use CREATE TABLE AS SELECT.