Views

A view is a stored query that encapsulates one or more SELECT statements. Views dynamically access and compute data from the database at execution time. A view is read-only, and can reference any combination of tables, temporary tables, and other views.

You can use views to achieve the following goals:

Unlike projections, views are not materialized—that is, they do not store data on disk. Thus, the following restrictions apply: