5 Comments
Apr 26Liked by Yordan Ivanov

In your example your source is a seed, what if my source is a {{ source('') }}, how do you mock it in this case?

Expand full comment
author
Apr 27·edited Apr 27Author

Hi Nikita, I'm not sure I understand your question. The seed is just an easy way to store fake data. If you want to store that data into a database and use the `source` macro, I don't see a reason why you not.

Expand full comment
May 3Liked by Yordan Ivanov

I will be trying to adopt dbt testing again soon, will revisit your strategy. You reference your initial data/sources/seeds as ref(), which is also a way to reference seeds in dbt. In my models my initial data is coming from tables populated in prod by outside services and I reference those tables with source() dbt function. Maybe I made a mistake somewhere but your approach didn't work for me, I will be revisiting it next week and will post a comment with results. Meanwhile if my comment makes sense to you I would be glad to receive any suggestions.

Expand full comment

Very awesome

Expand full comment
author

Thank you!

Expand full comment