On the server with the metadata catalog, execute the following command:
SELECT column_id, column_name, column_type
FROM axe_catalog.pga_column
WHERE
table_id = table_ID AND
snapshot_ID >= begin_snapshot AND
(snapshot_ID < end_snapshot OR end_snapshot IS NULL)
ORDER BY column_order;
Where:
table_ID: The ID of the analytical table
from the
pga_table
metadata table that contains the column.
snapshot_ID: The ID of the snapshot from
the pga_snapshot
metadata table.