Hi .. Thanks do we use Savepoints in ETL pipeline?
@SoftwareNuggets
Жыл бұрын
Hey @vivekpuurkayastha1580, Yes, Savepoints can be used in PostgreSQL ETL pipelines. They help create checkpoints within transactions, allowing for partial rollbacks if errors occur. By defining Savepoints at key stages of the pipeline, you can ensure data consistency and resume processing from a known good state in case of failures, without restarting the entire process. Hope this helps.
@rmathew733
9 ай бұрын
By default Postgres do a AUTO COMMIT right?
@SoftwareNuggets
9 ай бұрын
Hey @rmathew733, you are right, the default transaction type is the autocommit. Each sql statement will be executed in its own transaction. Some would say, the autocommit is implicit.
Пікірлер: 6