Tracking fields

Models built on databases and data warehouses (whether SQL or NoSQL) allow you to specify a tracking field. Typically this will be an updated_at or last_modified field (for the technical crowd: any field that is monotonically-increasing with each update).

Setting this would result in much lighter queries to your database or your data warehouse, as Polytomic would monitor this field to detect changes to your data rather than running full scans every time to figure out table changes.

🚧

Data Backfills

If you change your sync configuration to include new mappings, data will not backfill for records already synced in the past. The way to backfill is to click the 'Force full resync' button on the Sync Status page.