Chapter 25. Analytical Tables

Table of Contents

25.1. Creating an Analytical Table (metastore.add_table)
25.1.1. Creating an Analytical Table from a Parquet File
25.1.2. Creating an Analytical Table From a Heap Table
25.2. Renaming an Analytical Table (metastore.rename_table)
25.3. Creating a Postgres Pro View For an Analytical Table (metastore.create_view)
25.4. Deleting an Analytical Table (metastore.remove_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.