Hello, I am using latest Airbyte v0.41.0 (running on EC2 Docker), Salesforce Connector 2.0.12 to synch into Snowflake.
Noticing few random records that have not synched. I am comparing with data synched via Fivetran. Issue is with high volume objects such as Accounts, Opportunities, Quotes and QuoteLines.
There isn't a specific pattern, and this only happens on few records. Has any one run into this?
Hmm, I don't know enough to give you a confident answer yet. However, I can suggest a few things you can try based on the information extracts: 1. Make sure you have the necessary permissions and roles for the authenticated Salesforce user to read and fetch objects. Airbyte fetches streams dynamically based on the user's permissions and if the stream has the queryable property set to true [source](https://docs.airbyte.com/integrations/sources/salesforce). 2. Check if there are any errors or issues in the sync logs. You can find some examples of issues and their resolutions in the [forum discussion](https://discuss.airbyte.io/t/3094) and [Slack conversation](https://airbytehq.slack.com/archives/C021JANJ6TY/p1669918086843689). 3. Consider updating your connectors to the latest versions if they are not already up-to-date. You can find the latest versions in the [Airbyte documentation](https://docs.airbyte.com). If you still face issues, I recommend posting your question along with the sync logs on the [Airbyte forum](https://discuss.airbyte.io) or [Airbyte Slack](https://airbytehq.slack.com) for further assistance.
s
Sathish
05/30/2023, 6:35 PM
FYI - I do see records with Modified Date-Timestamp before and after the modified timestap of the two 'missing' Account updates.
I have setup incremental synch with dedup. I checked RAW table, it does not have the modified records. Leads me to believe the record was missed by Airbyte. [Fivetran managed to bring these over, so the Salesforce does have the data]