Transformations: Salesforce Formulas DBT Solution - support TEXT function
PlannedHi,
A lot of the formulas are not supported because: ```The formula TEXT is not supported currently```.
For us currently the DBT package solves about 40% of the formulas, but if the 'TEXT' will be supported it will increase to like 65%
BTW I think this is quite easily translatable to SQL `convert(X as varchar)` :)
-
Official comment
Hi Yaara - Happy to share that we have now added support for formula fields that reference the TEXT function for all Postgres destinations.
Please reach out if you have any additional concerns.Thanks,
Shiva
-
Hi Yaara,
Thanks for writing in. The SQL translations are unique per destination type (bigquery/snowflake/etc). Could you confirm for which destination you're seeing this limitation?We will add support for this -- it's a matter of when, not if!
-
Hi Ray, Thanks for the response!
We're using PostrgresRDS destination across all our connectors.
Thanks,
Yaara
Please sign in to leave a comment.
Comments
3 comments