Transformations: Salesforce Fomula Utils - Exclude individual fields
Not plannedWhen working with salesforce_fomula_utils. sfdc_formula_view(...), it would be extremely useful to have an "exclude" parameter, whereby we can identify only those fields which are not working (generally formulas), and add them separately. , I see there is a parameter for "include", if we only want to bring in certain fields, but often we have too many fields to make this viable. An exclude parameter would allow us to more easily use the automated sql transformation, and add those fields which don't work directly in our model in a contained space.
I know we can exclude a formula with sfdc_exclude_formulas: in the dbt_project.yml file, but I'm not sure we necessarily want to exclude it from every table.
-
Official comment
Hi Hadi,
Thanks for your feedback here! We do currently only have exclusion via package level, not model level, so I can understand your pain point. We are working on a refactor of our dbt package that will be available in a few months and should cover this scenario. In the meantime, I hope that this missing feature doesn't totally block you from getting value from what we have available today!
Please sign in to leave a comment.
Comments
1 comment