Feature
Backfill history, then stay current.
Initial backfill plus incremental updates keep your data consistent.
Run an initial backfill and then keep your Supabase tables current.
Initial backfill
Sync available history within each platform's limits.
Incremental updates
Scheduled syncs keep your tables up to date.
Idempotent upserts
Re-sync without duplicate records.
Preview
Backfill history, then stay current
Run an initial backfill, then keep tables updated with incremental syncs.
Sync coverage
Example window (source limits apply)Historical backfillLast 30 days
Incremental updatesDaily
Backfills respect each platform's historical limits and plan settings.
How it works
1
Connect a source
Authorize the platform and select the account to sync.
2
Run the backfill
LightningSync pulls historical data based on platform limits.
3
Stay current
Incremental syncs keep the latest data flowing in.
Use cases
- Recover historical performance after a tool change.
- Keep attribution models stable over time.
- Fill dashboards with complete reporting windows.
FAQ
How far back can I go?
It depends on the source platform and the plan you are on.
Will duplicates appear?
No. Upserts prevent duplicate records.
Ready to start syncing?
Connect your first data source and see your tables populate.