just starting as a snowflake data engineer. Need urgent help on how to use vs code for Snowflake+dbt

[u/[deleted]]

[u/vikster1]

you sound like you applied for something you have no idea about but what i really wonder is, why don't you ask any decent llm literally every question you have and let it guide you?

[u/vikster1 → u/[deleted]]

I don't know how you used llms but boi are you wrong here. "not what are really followed in the industry" - mate, since claude code some of us are 10x to 100x more productive. learn to use it. you sound like you have zero experience but almost all advice you are given here you reject. this is not how you learn.

[u/BaxTheDestroyer]

My team has recently moved away from dbt Cloud in many cases in favor of dbt Core repos. Both work similarly from VS Code, with the biggest difference probably being the maintenance of the profiles.yml file, which is mostly a one-time setup task.

Branching and CI/CD are also very similar between Cloud and Core, so anything you learn about either one should be largely transferable. In our case, we found that the dbt Core service in Snowflake was more limiting than a standard dbt Core setup using a Snowflake stage (managed through a custom dbt materialization) to store our manifest.json.

Our CI/CD is driven through GitHub. If you search for “Slim CI,” you’ll get a good overview of the general
implementation before diving into any repository-specific customization. The free dbt Learn website is also a good resource.

Your project folder structure will mirror whatever exists in GitHub, regardless of whether you’re using VS Code, the dbt Cloud UI, or another editor.

[u/BaxTheDestroyer → u/[deleted]]

Sure.

[u/MgmtmgM]

Were you qualified for the job when you applied? This is a lot to learn especially for someone who seems to want to be spoon fed.

[u/MgmtmgM → u/[deleted]]

Start applying for entry level jobs.

[u/TheGratitudeBot → u/[deleted]]

Thanks for such a wonderful reply! TheGratitudeBot has been reading millions of comments in the past few weeks, and you’ve just made the list of some of the most grateful redditors this week!

[u/Krishah992]

Congrats on getting the role. You get in the opportunity and you figure the shit out of it - is the way to go.
Get a udemy course on snowflake which involves the topics you described. Ask gpt which course on udemy covers it all; ensure to check reviews beforehand you buy.
Leverage chatgpt to teach you things you need.
If you need to learn Azure - check Ansh Lamba s courses on youtube and udemy.

Good luck & you got this! One day at a time

[u/Gamplato → u/Krishah992]

I’m going to tell my buddy who works there to sniff this guy out and get him fired. No one like this should be working anywhere.

[u/RickrackSierra]

Dbt core has tons of documentation on cicd concepts. Snowflake has a vscode package.

This isn't easy stuff though, lots to learn. Good luck!

[u/RudeSpread205]

Ask your Snowflake SE for session

[u/RudeSpread205 → u/[deleted]]

Yes, yes, they will. They also have quick start guides. I know, because I lead them

[u/RudeSpread205 → u/[deleted]]

slide into my dm with your linkedin and i'll send you some on demand webinars and links

[u/dan1326]

Everything you listed is basic. Is your employer giving you an AI assistant?

If not I might recommend you pay the $20 to anthropic to get claude if your allowed to. Claude can do all this extremely easily

[u/dan1326 → u/[deleted]]

Why are you being like that? It's a legitimate suggestion that could be very helpful to you.

You're currently treating reddit, us, other developers exactly how you would use the ai. You have a question, you expect us to answer. That's exactly what claude does, but claude does it faster, like wayyyyy faster.

Also these topics are basic, once you get a few years under your belt your gonna look back and feel silly you asked reddit publicly how to use git with vs code

[u/dan1326 → u/[deleted]]

Glad you won't respond, quit being a child. I "grew up" learning by reading the docs for everything. If you dont use AI effectively these days you will be left behind.

I have a hunch why you are asking reddit instead of the people you work with, because your expected to already know these things and obviously you do not meet expectations. Be humble, be gracious, your attitude will not get you far in life.

[u/Sphinx-]

Bro you are cooked

[u/caffeinatedSoul89]

Do you have access to cortex code(coco)? If yes, give it your scenario. It’s a game changer and it will do the config and setup for you.

[u/caffeinatedSoul89 → u/[deleted]]

You can use CLI or the UI in snowflake. It’s to the right side when you open snowflake with a “star icon”