SFTP logo
§ Agent · SFTP

The SFTP data agent that acts the way you would.

It watches your SFTP file drops alongside the rest of your pipeline, on a schedule you set or whenever fresh data lands. When a delivery is late, a schema shifts, or row counts break trend, it tells you, or handles it the way you'd want.

D
DefiniteAPP9:14 AM · #pipeline-alerts
⚠️ orders_export missing from /incoming/partner: 6 hours past SLA, downstream models stale

The daily orders file from your fulfillment partner usually lands by 06:00 UTC. It is now 12:14 UTC with no new file. 3 dbt models and 2 dashboards depend on this drop. Last 30-day on-time rate was 97%.

Review & approve Dismiss
SFTP Stream (orders_export) · joined to warehouse load log · audit log

How an agent works

An agent watches one thing and acts on it. Not a workflow, just a standing watch that usually does nothing and acts the moment it should.

◄ repeats on the schedule you set ►

You stay in control

An agent does what you'd do, and only what you've authorized.

The same trusted numbers

It acts on the same governed metrics as your dashboards, and every action is logged and traceable.

You approve anything that writes

It alerts and recommends on its own; anything that changes data is yours to approve.

Try it on a test channel first

Point a new agent at a throwaway channel and watch its judgment before it touches anything real.

No false alarms

It remembers what it already flagged and waits before acting again, so it won't alert you about the same thing twice.

What you can put an agent on

FreshnessACROSS YOUR SOURCES

Catch a late file drop before your stakeholders notice stale dashboards

It tracks every expected file delivery against its SLA window, cross-referenced with the downstream models and dashboards that depend on it. When a drop is late, it tells you which pipelines are blocked, how many hours of data are missing, and whether the vendor has been drifting, so you can escalate with evidence instead of guessing.

Stream (Dataset/Table)
Schema

Flag schema drift the moment a new file lands

When a partner changes a column name, adds a field, or shifts a delimiter, the agent catches it on the first file that deviates. It tells you what changed, which downstream tables are affected, and whether the change looks intentional or broken, before bad data propagates through your models.

Stream (Dataset/Table)
Volume

Surface row-count anomalies that signal upstream problems

It baselines the expected row count for each file pattern and flags when a delivery is dramatically lighter or heavier than normal. A 90% drop in your nightly transaction export is not something you want to discover during a Monday morning standup.

Stream (Dataset/Table)
Custom

Run any Python it needs to get the job done

Beyond alerts and write-backs, an agent can run arbitrary Python, so it can do whatever the task actually requires: call an API, kick off a job, reshape the data, or wire into your own tooling. The action space is yours to define.

Why not just build it yourself?

You could rig one of these with a cron job and a Slack webhook in an afternoon. The watching is the easy part. Here's what you'd own forever, and don't, here:

  • The cross-source join: not one tool's data, but it reconciled against the rest of your stack
  • A trusted, consistent metric: the same number your dashboards use
  • The investigation into why, when something fires
  • A full audit trail of everything it did
  • The upkeep, when the schema drifts or the script breaks at 2am

The data it works from

Every SFTP object, modeled and query-ready the moment you connect.

Stream (Dataset/Table)
general_data_storage

It runs on your real SFTP server (inconsistent delimiters, GPG-encrypted exports, mid-schema vendor changes and all), not a tidy demo.

Where it acts

Slack

A message in the channel you choose, with the context and a button to act on it.

Email

A summary in the inbox of the people who need to see it.

Webhook

A payload to your own systems, to wire the agent into whatever you already run.

Warehouse write-back

A flag written back to your warehouse for everything downstream to pick up.

Hand off to Fi

Kick the question to Fi to investigate the why and propose the fix.

MCP

Expose it to your own agents and tools over MCP, and drive it from your stack.

Run it in your own VPC or fully self-hosted. Everything it does is pure SQL and Python you can inspect.

Build your agents with Fi

Fi is your AI analyst. It helps you build and customize everything in Definite, including the agents that watch and act.

Fi

Your AI analyst. Ask questions in plain English, and let it help you build and customize everything in Definite, including your agents.

Meet Fi →

Agents

The watchers and actors. Once you've built one, it runs on its own, keeping an eye on what matters and acting the way you would.

Autonomous agents →

Get started

  1. 1Connect SFTP, and the sources it needs to reconcile against. Synced and modeled in an afternoon.
  2. 2See the numbers tie out to what you already trust.
  3. 3Put an agent on one thing you can't afford to miss. Fi helps you build it.
§ FAQ

Common questions

You set the schedule, and it also re-checks whenever fresh SFTP data lands. Each agent watches the one thing you point it at, nothing else.
It alerts and recommends on its own. Anything that writes, whether to a tool, your warehouse, or a customer, is yours to approve. You can also point a new agent at a test channel first and watch its judgment before it touches anything real.
When something fires, it can hand off to Fi to investigate, drilling into the data it has across your connected sources to find what's behind the move, and showing its work.

Your answer engine
is one afternoon away.

Book a 30-minute call and watch us build your first dashboard live, with your own data.