table_id

BIGINT

Primary key

The analytical table ID assigned by increasing the next_catalog_id value of the pga_snapshot metadata table.

table_uuid

UUID

NOT NULL, UNIQUE

The persistent analytical table ID stored for compatibility with heap tables.

begin_snapshot

BIGINT

Foreign key, NOT NULL

The snapshot associated with creating the analytical table, from the pga_snapshot metadata table.

end_snapshot

BIGINT

Foreign key

The snapshot associated with deleting the analytical table, from the pga_snapshot metadata table.

If the value is NULL, the analytical table is not deleted.

schema_id

BIGINT

NOT NULL, UNIQUE

The ID of the analytical schema that contains the analytical table, from the pga_schema metadata table.

table_name

VARCHAR

NOT NULL

The analytical table name, for example, my_table.

table_name values are not UNIQUE because pgpro_metastore does not delete the metadata of analytical tables. Deleted analytical tables are associated with end_snapshot values to indicate that these tables can no longer be used.

This allows you to create a new analytical table with the same name as a previously deleted table.

path

VARCHAR

NOT NULL, UNIQUE

The path to the storage directory with Parquet files of the analytical table relative to the uri value of the pga_storage metadata table.

The absolute path is generated by concatenating the uri value of the pga_storage metadata table and the path value of the pga_table metadata table.

storage_id

BIGINT

Foreign key, NOT NULL

The ID of the storage that contains the analytical table, from the pga_storage metadata table.

view_sql

VARCHAR

-

The CREATE VIEW command used to create a Postgres Pro view for the analytical table.

was_evolution

BOOLEAN

NOT NULL

Specifies whether the metadata of the analytical table was updated using the following stored procedures:

This information is used by the metastore.create_view operation.

proxy_table_id

BIGINT

NOT NULL, UNIQUE

The ID of the proxy table associated with the analytical table, from the pga_proxy_table metadata table.