Trigger icon
SlackIncomingWebhook icon
ForEach icon
JsonToIon icon
Batch icon
Run icon

S3 File Trigger to Postgres with dbt Transformations

File driven Kestra ETL that detects new S3 objects, batch inserts each file into Postgres in parallel, runs dbt transformations, and sends Slack alerts on failure.

Categories
Data

More Data Blueprints

Sync Postgres records to Algolia index

Incrementally push freshly updated Postgres rows into an Algolia search index every five minutes.

Trigger icon
ForEach icon
Index icon
Query icon
postgresql icon
Business Data
Run a Scheduled ETL Sync with Airbyte Cloud

Trigger an Airbyte Cloud connection sync on a recurring schedule so your data lands fresh without manual runs.

Sync icon
Schedule icon
Data
Trigger an Airflow DAG

Trigger an Apache Airflow DAG from Kestra and wait for it to finish.

TriggerDagRun icon
Data
See How

New to Kestra?

Use blueprints to kickstart your first workflows.

Get Started