> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Snowflake information_schema

> The Snowflake-shaped information_schema views available under dialect=snowflake.

Under [dialect=snowflake](/reference-sql/snowflake/overview), a supported `information_schema` view follows [Snowflake's `INFORMATION_SCHEMA`](https://docs.snowflake.com/en/sql-reference/info-schema): its column names and order.

## Supported views

* `information_schema.tables` ([Snowflake reference](https://docs.snowflake.com/en/sql-reference/info-schema/tables)).
* `information_schema.columns` ([Snowflake reference](https://docs.snowflake.com/en/sql-reference/info-schema/columns)).
* `information_schema.views` ([Snowflake reference](https://docs.snowflake.com/en/sql-reference/info-schema/views)).
* `information_schema.schemata` ([Snowflake reference](https://docs.snowflake.com/en/sql-reference/info-schema/schemata)).
* `information_schema.databases` ([Snowflake reference](https://docs.snowflake.com/en/sql-reference/info-schema/databases)).

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`.