A view is a curated, virtual tabular result defined by a query over one or more underlying tables. It organizes information for analysts and other users without requiring them to reconstruct the underlying query each time. section 1.2.2
Views support organized access to warehouse data by:
- Combining logically organized information from multiple underlying tables. section 1.2.2
- Giving analysts a curated structure for generating insights. section 1.2.2
- Making defined data structures available to a group of users through query-language tooling. section 11.3.1
A query-backed analytical result
A warehouse query can group city population records by state and calculate total population. Such a result illustrates how query logic produces organized information for analysis. section 1.2.2
