SQL Views
A saved query that behaves like a table — but always reflects the live, current data underneath it.
What & Why
A view is a named, stored query. Selecting from a view runs that underlying query fresh every time — a view never stores its own copy of data, it's just a saved shortcut for a SELECT you'd otherwise have to retype.
See How It Works
BUSINESS QUESTION
Define a reusable active-campaign result from the real marketing table.
| id | name | channel | spend | start_date | end_date | status | target_segment |
|---|---|---|---|---|---|---|---|
| 1 | Spring Launch | google_ads | 55000.00 | 2024-01-15 | 2024-03-31 | active | smb |
| 2 | Retention Webinar | 45000.00 | 2024-02-10 | 2024-04-15 | active | enterprise | |
| 3 | Finance Retargeting | 50000.00 | 2024-03-12 | 2024-05-31 | active | enterprise | |
| 4 | Enterprise Search | google_ads | 60000.00 | 2024-04-01 | 2024-06-30 | active | enterprise |
EXAMPLE QUERY
CREATE VIEW public.active_campaign_summary AS
SELECT
id AS campaign_id,
name,
channel,
spend,
start_date,
end_date
FROM marketing.campaigns
WHERE status = 'active';RESULT — public.active_campaign_summary
| campaign_id | name | channel | spend | start_date | end_date |
|---|---|---|---|---|---|
| 1 | Spring Launch | google_ads | 55000.00 | 2024-01-15 | 2024-03-31 |
| 2 | Retention Webinar | 45000.00 | 2024-02-10 | 2024-04-15 | |
| 3 | Finance Retargeting | 50000.00 | 2024-03-12 | 2024-05-31 | |
| 4 | Enterprise Search | google_ads | 60000.00 | 2024-04-01 | 2024-06-30 |
The standard view exposes the six-column active-campaign contract while reading current marketing.campaigns rows.
This lesson's practice is part of Pro.
Sign up free to try it on a real business scenario