View

Introduction to views

Materializations define the way our model is stored and updated in the data warehouse. There are four types of materializations:

• Tables

• Views

• Incremental models

• Ephemeral models

Views are the default materialization. Views don’t store the data, they just store an SQL query. There are two major pros to using views:

• They’re always up-to-date.

• There’s no storage cost.

The major downside, on the other hand, is that those queries have to be executed every time, so they can be very slow to query and generate high costs.

Because views are the default, this model would be a view: