Output
Azure SQL Output
Writes the rows that reach it into an existing Azure SQL table, in one transaction, and passes them on unchanged.
When to use it
Use it to publish results to Azure SQL for Power BI, another application or a later flow.
In a pipeline
File InputAzure SQL Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Target Table | select | Yes | Select a table |
| Write Mode | select | — | append |
| Key columns | select | — | Columns that identify a row |
Example
Write results
- Target Table=dbo.DailyTotals
- Write Mode=Replace existing rows
| Day | Total |
|---|---|
| 2026-10-16 | 4120 |
| 2026-10-17 | 3890 |
| Day | Total |
|---|---|
| 2026-10-16 | 4120 |
| 2026-10-17 | 3890 |
Worth knowing
- Replace existing rows empties the table first, in the same transaction — a failed insert leaves the old rows in place.
- Up to 1,000 rows go in each INSERT, fewer for wide tables (the 2,100-parameter limit). Upsert deletes the incoming keys first, in the same transaction.
- Previews never write.