Why Do the last_modified_date and _fivetran_synced Values Differ for Some Records in theSURVEY_RESPONSE Table?

Question

Why do the last_modified_date and _fivetran_synced values differ for some records in the SURVEY_RESPONSE table?

Environment

Connector: Qualtrics

Answer

During each sync, we re-fetch survey responses from the previous day. When this happens, we update the _fivetran_synced value to reflect the day we re-fetched the data. As a result, the last_modified_date and _fivetran_synced values may differ by one day for some records in the SURVEY_RESPONSE table.