Automations

Put the busywork on a schedule.

Schedule pipelines, alerts, and delivery so your data runs itself — and drop into Python the moment configuration isn't enough. No separate orchestrator to stand up or babysit.

How it runs

One pipeline, start to finish.

A schedule kicks off an ordered run: ingest your sources, transform with SQL, validate freshness, then deliver. Every run does exactly the same thing — so the numbers your team wakes up to are always current and always agree.

Automation · orders_daily
scheduled · daily 06:00 UTC
Trigger
On a schedule
cron · or event
──── runs the steps in order ────►
Pipeline
Ingest
sync sources
Transform
SQL models
Validate
tests + freshness
Custom step
{ } embedded Python
Deliver
Alert
Slack #ops on anomaly
Email digest
stakeholders · 06:30
Reverse ETL
push to CRM + sheets
deterministic — every run does exactly the same thing, in the same order.

Everything the run needs — in one place.

Schedules & triggers

Run on a cron schedule or off an event. Pipelines, models, and refreshes execute in order, with dependencies handled for you.

Alerts that find you

Watch a metric or a freshness check and get pinged in Slack or email the moment a run fails or a number looks off.

Delivery & reverse ETL

Push results back to the tools your team lives in — Slack, email digests, sheets, or straight into your CRM and other systems.

Embedded Python

When configuration isn't enough, drop into a Python step in the same pipeline. No external orchestrator, no glue infrastructure to run.

From one-off to automated in four steps.

  1. 1Build the pipelineConnect sources and model your data with SQL — or have Fi draft the first version for you.
  2. 2Put it on a schedulePick a cadence or an event trigger. Steps run in dependency order, every time.
  3. 3Add alerts and deliveryWire up anomaly and freshness alerts, then route results to Slack, email, sheets, or downstream systems.
  4. 4Drop into Python when you need itAdd a custom Python step for anything configuration can't express — it runs inline as part of the same automation.

Explore the rest of the platform

Your answer engine
is one afternoon away.

Book a 30-minute call. We'll build your first dashboard on the call — or you can stop paying us.