Connector Improvement: How to select the Derived Columns which are flowing from the source and not getting selected
Not planned
Hello Team,
I am encountering an issue when trying to include derived columns which are coming from Source (Salesforce).
When checked in the Fivetran sync for SALESFORCE_PROD schema I could see that for table PLATFORM_CONNECTION_C the 2 columns Current_Record_Num, Integer_From_Nm_Num are not selected.
When trying to enable those since those were derived columns it says should be replicated with Transformations or you could enable the Sync Formula Fields Directly toggle in the setup form to sync them directly.
Below are the snapshots for the same. Could you please look into
-
Official comment
Hi Venkata,
We recommend you use our Quickstart data models to sync formula fields. Read more here: https://fivetran.com/docs/connectors/applications/salesforce/formula
Alternatively, you can go to the setup form for your connector and select the option to directly sync formula fields. This will not guarantee that the fields are kept up to date. The documentation linked above explains why.
Please file a Support ticket if you have any more questions.
Best,
Sadie
Please sign in to leave a comment.
Comments
1 comment