How to Create a View in Redshift
Last updated July 25, 2026 · By the SaturnSQL team
Use CREATE OR REPLACE VIEW ... AS SELECT. Add WITH NO SCHEMA BINDING to make it late-binding, so the view survives the underlying tables being dropped or recreated and can reference external tables.
CREATE OR REPLACE VIEW active_customers AS
SELECT id, email, last_seen_at
FROM customers
WHERE NOT churned;Late-binding view
Late-binding views must fully qualify every table name and are only validated when queried, which is what makes them robust to table rebuilds.
CREATE OR REPLACE VIEW reporting.active_customers AS
SELECT id, email, last_seen_at
FROM public.customers
WHERE NOT churned
WITH NO SCHEMA BINDING;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