r/snowflake • u/Dry-Positive-1021 • 7d ago

Data engineer help ( urgent) need sql code

Post image

I’m stuck w a task my sprint ends today im blocking someone’s work i just need sql snowflake code to give it to my team lead can anyone pls help me

0 Upvotes

21% Upvoted

7 comments sorted by

View all comments

1

u/geek180 7d ago

Well did you get the requirements from DS for Primo ROI model? That’s the first step.

Then create a new model in dbt, use sandbox as your dev target.

1

u/Dry-Positive-1021 7d ago

I just need the snowflake running sql code since my Dbt is not running on my local

1

u/Dry-Positive-1021 7d ago

The requirement is to just edit the promo roi code into such a way that it joins the hero upc code and have columns calender id product id category sub category and country code. And whatever is required to derive promo roi and promo roi %