snapshot_id

BIGINT

Primary key

The snapshot ID.

The value is increased by 1 for each created snapshot.

This is a primary key referred to by most metadata tables.

snapshot_time

TIMESTAMP

NOT NULL

The snapshot creation date and time.

schema_version

BIGINT

NOT NULL

The pgpro_metastore catalog version.

The value is increased by 1 at each pgpro_metastore object update, for example, when a new analytical table is created.

next_catalog_id

BIGINT

NOT NULL

The ID assigned to the next pgpro_metastore object, such as an analytical table.

The value is increased each time an object is created.

next_file_id

BIGINT

NOT NULL

The ID assigned to the next created Parquet file.

The value is increased each time a file is created.

is_visible

BOOLEAN

NOT NULL

Specifies whether pgpro_metastore objects referring to the snapshot are visible.

Possible values:

When an ETL operation, such as add_table, creates multiple objects referring to the same snapshot, the is_visible value is set to false for this snapshot. New objects are not visible until the operation is executed.

After this, the is_visible value is set to true for the snapshot, and new objects become visible, i.e., they are in the SELECT command output.

You can use the is_visible value to temporarily hide an object without deleting it and then make it visible again later.