Other: Fivetran package salesforce_formula_utils not working as expected
The Fivetran package salesforce_formula_utils
has a bug and it can’t recognize our database data_lake
as the source of the Salesforce models, and it’s trying to get it from dw_prod
database (The default database). This is defined in the source.yml of each staging directory in dbt, in this case in the staging/salesforce/salesforce.
l file. But it’s skipping the database parameter and it’s trying to get it from prod as you can see in the first image attached (the query is from target/run/models/salesforce/
, that is where the macro of the package creates the model). The error we are getting now is attached as an image.
Expected Behavior:
FROM "DATA_LAKE"."SALESFORCE"."CAMPAIGN"
Current Behavior:
FROM "SALESFORCE"."CAMPAIGN"
Please sign in to leave a comment.
Comments
0 comments