The "DEAL_HISTORY" table synced from Pipedrive is keeping the history of deals within Pipedrive through a SCD 2.
As explained here https://fivetran.com/docs/getting-started/feature#history , it is done though a composite key with the id and the timestamp of the last update to the record identified by the id.
In new connectors, Fivetran seems to have enhanced the way the slowly changing dimensions are tracked by inserting 3 columns: https://fivetran.com/docs/getting-started/feature/history-mode
Those 3 columns are making the data querying easier.
Would it be possible to use this new pattern for the DEAL_HISTORY table of Pipedrive?
Please sign in to leave a comment.