Get icon
Query icon
Queries icon
If icon
SlackIncomingWebhook icon
Set icon
Schedule icon

SQL Server Transactional MERGE Upsert with Watermark

Orchestrate an idempotent, transactional MERGE upsert into SQL Server with Kestra. Stage changed rows, MERGE with dedup, and advance a watermark atomically.

Categories
Data

More Data Blueprints

AI Document Data Extraction: Parse PDFs and Web Pages into Structured JSON with OpenAI

Turn any PDF, web page, or text document into structured JSON with OpenAI GPT-4o, then store the results in PostgreSQL and Slack.

Download icon
Script icon
ChatCompletion icon
Queries icon
SlackIncomingWebhook icon
AI Data
AI-Powered Inventory Demand Forecasting, Auto-Generate Purchase Orders with OpenAI

Forecast 7-day demand with OpenAI GPT-4o, auto-generate purchase orders for stockout-risk SKUs, and log them to PostgreSQL every 6 hours.

Parallel icon
Request icon
ChatCompletion icon
Script icon
If icon
ForEach icon
+3
AI Business Data
Generate and Execute SQL Queries from Natural Language Using OpenAI GPT-4o

Turn plain-English questions into PostgreSQL queries with OpenAI GPT-4o, grounded on schema only so no row data ever leaves your database.

Queries icon
ChatCompletion icon
If icon
IonToJson icon
Log icon
AI Data
See How

New to Kestra?

Use blueprints to kickstart your first workflows.

Get Started