search

fivetran / dbt_salesforce_formula_utils

Package containing dbt macros to help generate salesforce formula fields synced from Fivetran.
https://fivetran.github.io/dbt_salesforce_formula_utils/
Apache License 2.0
16 stars 18 forks source link

[Feature] Allow users to select materialization type in salesforce_formula_view #53

Closed abdullahhfz closed 2 years ago

abdullahhfz commented 2 years ago

Is there an existing feature request for this?

Describe the Feature

salesforce_formula_utils.salesforce_formula_view.sql hardcodes the materialization. As a user I am unable to change that, even if I set a configuration in the dbt_project.yml or create a config in the model sql file using CTE. The only way I can change the materialization is by changing the salesforce_formula_view.sql file and hard coding it to materialize as a table. This is problematic as I need to use these updated formula tables for downstream models.

There should be an argument that allows the user to change the materialization configuration of a model.

Describe alternatives you've considered

I have tried changing the config in the dbt_project.yml. Also, tried changing the config in the model sql file above the macro. I have also created a CTE using the macro and then overriding the config in the model sql file. None of these solutions work. Only hardcoding the salesforce_formula_view.sql file.

Are you interested in contributing this feature?

Anything else?

No response

fivetran-joemarkiewicz commented 2 years ago

Closed this issue as the feature has been implemented in the latest version of the package.