Snapshot Reports (v16) — Does hourly/daily sync show live transactions?

Frappe Framework
,
1

Hi everyone,

I’m looking into the new Snapshot Reports feature in Frappe/ERPNext v16 and want to confirm how data freshness works.

Setup

  • Snapshot Reports enabled in System Settings → Advanced
  • Frequency set to Hourly or Daily
  • Snapshot Report enabled on an accounting report (e.g. Trial Balance / General Ledger)

Question

If I create/post an accounting transaction right now, will that transaction appear immediately when I run the Snapshot Report?

Or will it only appear after the next scheduled DuckDB sync (hourly/daily)?

What I understand so far

Snapshot Reports query a DuckDB snapshot synced from MariaDB on a schedule, not the live database. So I’m assuming new transactions won’t show until the next sync — but I’d like confirmation from the team/community.

Also:

  1. Is there any way to force a manual sync before the scheduled job?
  2. For live/up-to-date accounting data, should we keep Snapshot Report disabled and use the normal report path?

Thanks in advance!

1 Like
2

Correct.

Is there any way to force a manual sync before the scheduled job?

Manually make a ‘DuckDB Sync’ record. This triggers a sync.

Yes.

Some Context

DuckDB integration is intended for extremely large sites - think 100s of million of rows. That’s the scale OLAP truly makes sense. Hence the snapshot style syncing.

1 Like