We’re excited to announce the general availability of Upsert method and Script activity support in Microsoft Fabric 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. The Script activity allows you to 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.