Chapter 16. Analytical Tables

Table of Contents

16.1. Creating an Analytical Table
16.1.1. Creating an Analytical Table from a Parquet File
16.1.2. Creating an Analytical Table From a Heap Table
16.2. Renaming an Analytical Table
16.3. Creating a Postgres Pro View From an Analytical Table
16.4. Deleting an Analytical Table

Analytical tables are sets of columns and rows with the OLAP data featuring a full history of data and table type updates.

Rows of analytical tables are stored as Parquet files in a storage. The metadata of analytical tables is stored in the pga_table metadata table.