Connector Improvement: dbt_salesforce_formula_utils Support for Reserved Keywords
Completed
Issue 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 -
Looks like I opened another issue that's basically duplicative of this one: https://github.com/fivetran/dbt_salesforce_formula_utils/issues/65
Following along to see what the fix ends up being here.
Please sign in to leave a comment.
Comments
2 comments