CATALOG_SUBSCRIPTION_CHANGES

Lists the changes made to catalog subscriptions.

Column Name	Data Type	Description
`EVENT_TIMESTAMP`	TIMESTAMP	The time a catalog subscription changed.
`SESSION_ID`	VARCHAR	A unique numeric ID assigned by the Vertica catalog, which identifies the session for which profiling information is captured. This identifier is unique within the cluster at any point in time but can be reused when the session closes.
`USER_ID`	INTEGER	A unique numeric ID assigned by the Vertica catalog, which identifies the user.
`USER_NAME`	VARCHAR	The user who made changes to the subscriptions.
`TRANSACTION_ID`	INTEGER	Identifier for the transaction within the session, if any. If a session is active but no transaction has begun, TRANSACTION_ID returns NULL.
`SHARD_NAME`	VARCHAR	The name of the shard.
`SHARD_OID`	INTEGER	The OID of the shard.
`SUBSCRIBER_NODE_NAME`	VARCHAR	The node name or names subscribed to the shard.
`SUBSCRIBER_NODE_OID`	INTEGER	The OID of the subscribing node or nodes.
`OLD_STATE`	VARCHAR	The previous state of the node subscription.
`NEW_STATE`	VARCHAR	The current state of the node subscription.
`WAS_PRIMARY`	BOOLEAN	Defines whether the node was the primary subscriber.
`IS_PRIMARY`	BOOLEAN	Defines whether the node is currently the primary subscriber.
`CATALOG_VERSION`	INTEGER	The version of the catalog at the time of the subscription change.