How to Create a Schema in Redshift
Last updated July 25, 2026 · By the SaturnSQL team
Use CREATE SCHEMA, optionally with AUTHORIZATION to set the owner and QUOTA to cap how much disk space the schema's tables may use. DROP SCHEMA ... CASCADE removes it with all its objects.
CREATE SCHEMA IF NOT EXISTS analytics AUTHORIZATION analytics_admin QUOTA 100 GB;Check schema quotas and usage
SELECT schema_name, quota, disk_usage, disk_usage_pct
FROM svv_schema_quota_state;When a schema hits its quota, transactions that grow it are aborted. Set QUOTA UNLIMITED (the default) for schemas that should not be capped.
Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free