Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Salesforce Picklist Value History Table

Answered
Lyell Galbraith User

Which destination?: FIVETRAN_PICKLIST_FIELD_VALUE

 

Additional details: For Salesforce picklist values Fivetran syncs FIVETRAN_PICKLIST_FIELD and FIVETRAN_PICKLIST_FIELD_VALUE which are snapshot tables, meaning if picklist values are deactivated in Salesforce they're removed from Fivetran. 

There should be an option to either set these tables as changelog tables, or enable another set of tables that are changelogs.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Vignesh Rengaraj Fivetranner

    Thanks, Lyell, for raising this. We have seen similar recent requests from other customers who want to track when picklist values get deactivated, so it has been on our radar.

    A few questions on the use case:

    1. Could you tell us more about the use case you are trying to achieve or what downstream workflow breaks when a deactivated value disappears?
    2. Would adding an is_active / deactivated_at column to the existing snapshot tables (soft-delete style) solve it, or do you specifically need a full changelog that captures every transition over time?

    Best,
    Vignesh
    Fivetran Product