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

Community

Connector Improvement: Fivetran Quickstart model schema which we're using for Formula fields for SalesForce connector is not replicating the deleted records

Planned
Saurav Chugh User
  • Edited

This is regarding the Fivetran SalesForce connector. We're using the Quickstart model schema for formula fields transformation. 

Currently Fivetran is having a where clause that filters out deleted/inactive records in the QuickStart schema(Attached screenshot for the reference). This impacts the downstream processes . Based on the discussion with Fivetran to proceed with any changes, we would require a feature request to remove this where clause.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Shivaprasad Mogili Fivetranner

    Hi Sourav, 

    Thanks for submitting this feature request. I've added this to our backlog as this is something we want to support. 

    We can offer a workaround at this time to address your immediate need, you can fork our DBT package: https://github.com/fivetran/dbt_salesforce_formula_utils to modify the macro to do a string replace of the part of the formula to not filter deleted records. You can reach out to your Fivetran account rep to get more assistance on this approach. 

    Thanks,

    Shiva