easy5 pts · first answer countsdata-warehousingdbtjinja

Reusing SQL logic in dbt

Ten models repeat the same CASE expression that converts paise to rupees and rounds it. What is the dbt way to avoid repeating it?

A.Copy it into a seed fileB.Create a separate model for each copyC.Write a Jinja macro and call it in each modelD.Put it in profiles.yml

Discussion 0

Join free to post in the discussion.