Announcing the general availability of the Upsert method and Script activity support in Azure Data Factory and Azure Synapse Analytics when using Azure Database for PostgreSQL. This enhancement enables you to perform efficient, scalable, and declarative data transformations directly within your pipelines.
With the Upsert method, you can now merge incoming data into existing tables without writing complex logic, reducing overhead and improving performance. With the Script activity, you can execute custom SQL scripts as part of your data workflows, enabling advanced transformations, procedural logic, and fine-grained control over data operations.
These capabilities streamline extract, transform, load (ETL) and extract, load, transform (ELT) processes and unlock new flexibility for building robust data integration solutions using Azure Database for PostgreSQL as a source or sink.