Syncs

Push a query result somewhere else, on a schedule.

Read time: 4 min
Sections: 4

What a sync does

A sync runs a saved query and writes the result into another system — a spreadsheet the finance team already lives in, a channel, or an endpoint of your own.

A report delivers something a person reads. A sync delivers something another system consumes. If the recipient is a human, you probably want a report.

Destinations

Google Sheets — The common one: a sheet other people already build on top of.
Slack — For results small enough to read in a message.
Webhook — Your endpoint, your format handling.

json

{
  "url": "https://hooks.example.com/datarunner",
  "secret": "whsec_..."
}

Replace or append

Replace overwrites the destination on every run — the sheet always holds the current answer. Append adds to what is already there, which builds a history but grows without limit and will eventually need pruning by you.

Syncs do not apply column masking. A sync exists to move real data into another system, so a column masked for viewers is written in full. Point syncs at destinations you would trust with the source table.

Run history

Each run records rows read and rows written. Those two disagreeing is the signal worth watching: it usually means the destination rejected something rather than that the query changed.