Postgres Pro AXE : Documentation: 1: 38.2. pga_snapshot_changes : Postgres Professional

38.2. `pga_snapshot_changes`
Prev	Up	Chapter 38. Metadata Tables	Home	Next

38.2. `pga_snapshot_changes` #

This metadata table contains information about snapshot changes. You can use it to resolve conflicts between different snapshots.

Column Name	Column Type	Constraint	Description
`snapshot_id`	`BIGINT`	Primary key, foreign key	The ID of the snapshot from the `pga_snapshot` metadata table.
`changes_made`	`VARCHAR`	-	A comma-separated list of snapshot changes in the following formats: `created_schema`:`schema_name`: The snapshot is associated with creating an analytical schema. `created_table`:`table_name`: The snapshot is associated with creating an analytical table. `created_view`:`view_name`: The snapshot is associated with creating a Postgres Pro view. `inserted_into_table`:`table_ID`: The snapshot is associated with adding the OLAP data to an analytical table using the `metastore.add_files` or `metastore.copy_table` operation. `deleted_from_table`:`table_ID`: The snapshot is associated with deleting Parquet files with the OLAP data from an analytical table. `dropped_schema`:`schema_ID`: The snapshot is associated with deleting an analytical schema. `dropped_table`:`table_ID`: The snapshot is associated with deleting an analytical table. `dropped_view`:`view_ID`: The snapshot is associated with deleting a Postgres Pro view. Views can be deleted together with analytical tables depending on the deletion parameters. `altered_table`:`table_ID`: The snapshot is associated with updating the metadata of an analytical table using the following stored procedures: `metastore.rename_table` `metastore.add_column` `metastore.rename_column` `metastore.change_column_type` `metastore.delete_column` `altered_view`:`view_ID`: The snapshot is associated with updating the metadata of a Postgres Pro view.

Prev	Up	Next
38.1. `pga_snapshot`	Home	38.3. `pga_schema`

epub pdf