Hi, please redirect me if i’m asking in the wrong place.
When I need to add a new object to my salesforce extract, it is my understanding that I have to refresh the schema and re-select all of the original object plus the new one and also set the sync type over again. Is there an easier way or is this how it is to be done?
Since doing this resets the destination table, we’ll lose incremental history. Am I correct in assuming we’ll just need to copy those tables separately before the reset if we want to maintain that history?
Lastly, what is the incremental logic based on with Salesforce? I assumed it would be Created and or Modified date, but i’m seeing a new copy of each record pulled with every extract that is a complete clone except for the airbyte metadata. Is this a misconfiguration on my part?