search

LewisDavies / upstream-prod

A dbt package for easily using production data in a development environment.
32 stars 4 forks source link

Error When Using ref.sql Macro #22

Closed sdblanchard closed 4 months ago

sdblanchard commented 12 months ago

Hello,

I recently installed upstream_prod in my dbt/snowflake instance. Our team uses custom schemas, and I was able to effectively load production data into my dev environment by replacing the refs in the model with upstream_prod.ref. However, I'm now encountering an error when attempting to overwrite the default macro with ref.sql. Specifically, I'm receiving a 'dbt_macro__ref' takes no more than 6 argument(s) error. Could you potentially provide some guidance on how to navigate this issue? Thank you.

image

LewisDavies commented 10 months ago

Hey @sdblanchard, really sorry for the slow reply - having a new job and new kid doesn't allow much spare time! Which version of the package are you using? Since you're using dbt v1.3 you should be on v0.5.1 of the package (or earlier) and macros/ref.sql should look like this.