Roy Peter
02/08/2022, 4:05 AMHarshith (Airbyte)
02/08/2022, 6:21 AMRoy Peter
02/08/2022, 9:11 AM##Account table
Redshift
select count(*) from sf_airbyte_redshift_prod_v1."account" where isdeleted = false; 33511625
SF Bulk API
SF 33602898
33602898-33511625 = 91273 missing records
Harshith (Airbyte)
02/09/2022, 6:22 AMRoy Peter
03/07/2022, 5:15 PMRoy Peter
03/07/2022, 5:25 PMMarcos Marx (Airbyte)
03/07/2022, 11:55 PMMarcos Marx (Airbyte)
03/07/2022, 11:56 PMRoy Peter
03/08/2022, 1:12 PMRoy Peter
03/08/2022, 1:15 PMMarcos Marx (Airbyte)
03/08/2022, 9:15 PMwe do not see any data mismatch in low frequency tables and in the initial loadThis is running without S3 staging?
Marcos Marx (Airbyte)
03/08/2022, 9:15 PMWe triggered a sync with below changes to validate our hypothesis (some inflight data is getting missed at the end of each sync)Any chances your Salesforce had a different Timezone and Airbyte is not recognizing it?
Roy Peter
03/11/2022, 6:58 AMSystemModstamp
Logs
2022-03-10 06:21:27 source > Setting state of Opportunity stream to {'SystemModstamp': '2022-03-10T03:51:07.000+0000'}
2022-03-10 06:21:29 source > Setting state of Opportunity stream to {'SystemModstamp': '2022-03-10T06:21:18.000+0000'}
In Salesforce few records are present with 2022-03-10T06:21:14.000Z
timestampRoy Peter
03/11/2022, 7:19 AMMarcos Marx (Airbyte)
03/11/2022, 8:58 PMRoy Peter
03/12/2022, 7:20 AMRoy Peter
03/12/2022, 7:25 AMMarcos Marx (Airbyte)
03/15/2022, 12:12 AMBtw, above mentioned hack is working with a larger time overlap (3hrs)editing the connector code?
Roy Peter
03/20/2022, 7:17 PM