ETL operations also support the atomicity of object updates. If an operation is canceled, all intermediate data is deleted, and updates of metadata tables are not committed.

Even if procedures update pgpro_metastore objects in one transaction, additional service transactions are committed to log data updates. Logs allow canceling updates when the server fails or reloads. You can do this by executing the following query:

  SELECT metastore.cleanup();