How to Create a Schema in Snowflake

Last updated July 24, 2026 · By the SaturnSQL team

Use CREATE SCHEMA inside the current database, or qualify it as database.schema. Schemas namespace tables and views; grants on a schema cascade to future objects with future grants.

CREATE SCHEMA IF NOT EXISTS analytics.reporting;

GRANT USAGE ON SCHEMA analytics.reporting TO ROLE analyst;
GRANT SELECT ON FUTURE TABLES IN SCHEMA analytics.reporting TO ROLE analyst;