Cash Handling Audit Log Table

Dataset ID: 6723d00f-05a2-41f9-aa85-ae963c29f8b8

Unique Composite Key(s): id, storeid

Datetime Dataset Last Updated: last_retrieved_timestamp

Incremental Load Logic: Use the column “date” as data appends per new cash movement action completed

Pull Previous Day: Data-Raw Append Example:

{"sql": "SELECT * FROM table WHERE date(date) = date(date_add(now(), INTERVAL -1 day)) "}

Pull Previous Successful Update: Data-Raw Append Example:

{"sql": "SELECT * FROM table WHERE date(date) >= $stored_last_update_datetime"}

• stored_last_update_datetime is your stored datetime for last successful data pull

TIP: As a best practice, we recommend that you save the timestamp for each of your dataset pulls as 'stored_last_update_datetime'. Note that this value is not saved in our datasets, but is a suggestion.