fivetran_salesforce_quickstart.sbqq_quote_line_c.end_date_calculated_c has gone fully null
Answered
fivetran_salesforce_quickstart.sbqq_quote_line_c.end_date_calculated_c has gone fully null, which is causing 6 downstream tests to fail.Need help to understand the transformation and why is it causing nulls.
-
Official comment
Hi Sarita, thanks for reaching out, and sorry you're seeing null results on this Salesforce formula field.
This usually comes from one of two causes:
- Permissions changed upstream: the syncing account no longer has access to the formula field.
- Formula logic too long to process: common with Redshift destinations.
For #1, check whether Salesforce permissions changed and update them so the connector account can access the field. For #2, enabling the SUPER datatype at the destination level lets the connector process longer formula logic correctly.
Either way, I'd recommend opening a support ticket for deeper troubleshooting. Thanks!
Please sign in to leave a comment.
Comments
1 comment