Connector Improvement: dbt_salesforce_formula_utils Support for Reserved Keywords
PlannedIssue also opened on the dbt_salesforce_formula_utils GitHub page with additional detail.
We currently run into issues running sfdc_formula_view in the dbt_salesforce_formula_utils package for tables where calculated fields reference a field in another object named the same as a reserved Snowflake keyword.
For example, if I have an object called work_order
that has a calculated field referencing another object called order
(reserved in Snowflake), sfdc_formula_view
returns an "unexpected 'order' " error. Presumably because "order" is a reserved keywords?
-
Official comment
Hi Eric,
Thanks for calling this out! We have prioritized a solution here and will be avoiding use of reserved words in an upcoming fix. This is planned for rollout at the end of this week
Please sign in to leave a comment.
Comments
1 comment