Facebook Marketing fails to load data in incremental sync for custom query

  • Is this your first time deploying Airbyte?: No
  • OS Version / Instance: Ubuntu
  • Memory / Disk: 16Gb/500Gb
  • Deployment: Docker
  • Airbyte Version: 0.36.2-alpha
  • Source name/version: Facebook Marketing/0.2.51
  • Destination name/version: Big Query/1.1.8
  • Step: sync
  • Description: When syncing data from facebook marketing source it fails for a custom query when sync mode is set to incremental (it succeeds for full refresh).
    The error message is the following:

The custom query is defined as follows:

Hey not sure if this is the solution but wanted to suggest :sweat_smile:. Would you mind adding updated_time field and try again