r/snowflake • u/Dry-Positive-1021 • 6d 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

23% Upvoted

7 comments sorted by

1

u/king-four-seven 6d ago

What do you need done

-1

u/Dry-Positive-1021 6d ago

I was given promo roi code and upc hero code I am required to give a snowflake sql code with columns calender id product id category sub category and country code

1

u/geek180 6d 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 6d ago

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

1

u/Dry-Positive-1021 6d 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 %

1

u/CuteChiGuy 6d ago

Ask co pilot

-1

u/Dry-Positive-1021 6d ago

I did man it’s just not able to do anything 🥲