I am building out some models using the
sfdc_formula_view macro. When I set
full_statement_version = true, I get failing tests because there are some fields coming in (as currency) that are being set to STRINGs and their formulas no longer work. In this specific example, I'm getting an error because you can't coalesce a STRING and INT64. However, this is something we could work around.
The main issue is, If we just wanted to remove this field and continue testing or even operating in production with the current model, we couldn't use
full_statement_version = true. I've dug through the code quite a bit and since we are pulling the
model straight from the
fivetran_formula_model table, you can't cleanly remove the problematic formulas.
Step 5 in the README would leave you to believe that this
sfdc_exclude_formulas works regardless of if you are using Option 1, 2, or 3. It would be greatly beneficial if we could have Option 1 (grabbing nested formulas) also be able to exclude formulas from our models.
The problem is that this is tied to how Fivetran builds the `fivetran_formula_model` table.