27.14. pga_transaction_log Metadata Table #

This metadata table contains logging information about pgpro_metastore tasks analogous to standard DBMS transactions.

Column Name

Column Type

Constraint

Description

lsn

BIGSERIAL

Primary key

The transaction log sequence number (LSN).

txid

BIGINT

NOT NULL

The task ID.

op_id

INT

-

The ETL operation ID.

One task can consist of multiple ETL operations.

kind

VARCHAR

NOT NULL

The ETL operation type, such as add_storage, add_table, add_files, and create_view.

attr

JSONB

-

The initial and runtime data associated with the task.