How to Create a View in Snowflake
Last updated July 24, 2026 · By the SaturnSQL team
Use CREATE VIEW ... AS SELECT. Views run their query at read time; use a materialized view (Enterprise edition) or a table refreshed on a schedule when the query is expensive.
CREATE OR REPLACE VIEW active_customers AS
SELECT id, email, last_seen_at
FROM customers
WHERE churned = FALSE;Secure views
Add SECURE when the view definition or underlying data must be hidden from consumers, e.g. when sharing data across accounts.
CREATE SECURE VIEW customer_emails AS SELECT id, email FROM customers;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