Community

[Solved] Connector Improvement: Pipedrive // Deal History Slow Changing Dimension schema

Completed

Pierre de Poulpiquet User

Hello,

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?

Community