Cash Actuals & Expected Table

Dataset ID: e449c0b3-b172-4f7b-b8c0-f2f1de7bc925

Unique Composite Key(s): account_name, storeid, shift_dateopen

Datetime Dataset Last Updated: last_retrieved_timestamp

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

Pull Previous Day: Data-Raw Append Example:

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

Pull Previous Successful Update: Data-Raw Append Example:

{"sql": "SELECT * FROM table WHERE date(shift_dateopen) >= $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.