poll_cursors
2 rows
This data as json, CSV (advanced)
| Link | store | source | last_id | last_run_at | last_status |
|---|---|---|---|---|---|
| centralvapors,systemlog | centralvapors | systemlog | 7195970 | 2026-07-21T20:47:20.489911Z | ok |
| wholesale,systemlog | wholesale | systemlog | 116787 | 2026-07-21T20:47:20.751052Z | ok |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE poll_cursors (
store TEXT NOT NULL,
source TEXT NOT NULL, -- 'systemlog' | 'account_users' | 'account_apps' | 'state_diff'
last_id INTEGER, -- last BC System Log id we ingested
last_run_at TEXT,
last_status TEXT, -- 'ok' | 'error:<msg>'
PRIMARY KEY (store, source)
);