Building Analytical Views

The analytical views enable Arcadia Engine to cache frequently computed data. A SQL query is associated with that cached data, and the data is stored as an analytical view. The SQL query may perform grouping and aggregations, apply filters, and project columns. For more information on building analytical views, see Analytical Views Defined on Tables.

Next, consider and contrast Routing Queries To Analytical Views Defined on Tables and Routing Queries with Logical Views to Analytical Views.