What is Database View?

A view is a saved query that behaves like a table, so you can reuse complex logic and control which columns people can see.

Database View explained

The view stores the definition of the query, not a separate copy of the data (unless it is a materialised view). Each time you read it, the underlying query runs against current data.

Views are a common way to expose a clean, documented set of columns to analysts or tools while hiding sensitive fields or messy source tables.

Example

A view called active_customers can hold the rule for who counts as active, and every report simply selects from it.

Frequently asked questions

What is Database View?
A view is a saved query that behaves like a table, so you can reuse complex logic and control which columns people can see.
Can you give an example of Database View?
A view called active_customers can hold the rule for who counts as active, and every report simply selects from it.