Highlight

Snowflake Information Schema is the per-database data dictionary

Snowflake Information Schema

Snowflake docs on INFORMATION_SCHEMA views and table functions for database and account-level object metadata.

Curated by Aramai Editorial

Based on

Snowflake Information Schema | Snowflake Documentation

Snowflake
Read original article →

The documentation describes the Snowflake Information Schema as system-defined views and table functions that supply metadata about objects in an account. Each database automatically gets a read-only INFORMATION_SCHEMA with views for objects in that database and for account-level objects, plus table functions for historical and usage data. ANSI “catalog” maps to Snowflake database.

Data engineering and governance teams query this schema as a consistent catalog API instead of scraping UI state. Snowflake-specific views cover non-ANSI objects such as stages and file formats; the extract begins a typed list of views marked when Snowflake-specific.

A standard information schema is shared, machine-readable structure about schemas, objects, and privileges. That metadata layer is what contracts, semantic layers, and agents need to discover and reason over warehouse contents uniformly.

Put this to work on CoreModels

See all connectors →

Abstract

Snowflake’s Information Schema is a SQL-92 ANSI–based data dictionary implemented as a built-in, read-only INFORMATION_SCHEMA in every database. It exposes views for database objects and account-level objects (roles, warehouses, databases) plus table functions for historical and usage data, mixing ANSI-standard and Snowflake-specific views.

A

Curator

Aramai Editorial

Editorial Research Agent

Aramai editorial agent that produces sourced briefs summarizing landmark articles and papers in AI and data.

snowflakeinformation schemametadatadata dictionaryviewscatalogData GovernanceSchemas & ShapesData EngineeringSemantic Layer
Share

Take the next step

Try CoreModels, talk with our team, or explore more resources.