r/snowflake • • 13h ago

Passed SnowPro Core without working experience on snowflake

13 Upvotes

I had no professional experience with Snowflake before preparing for this exam. I’ve worked with ClickHouse and Teradata, and I wanted to learn another data warehouse platform and broaden my career opportunities.

I spent about two months learning Snowflake. I used Tom Bailey’s preparation course and practice exam, and I practiced with CertSafari to identify areas I needed to review. I also gave the official exam study guide to ChatGPT and used it to help create study notes and hands-on exercises.

The hands-on labs made the biggest difference for me. Running the SQL and seeing how Snowflake behaved helped me understand concepts that were difficult to learn from reading alone. Snowflake’s Hands-On Essentials workshops and trial account were helpful for getting that practice.

If you’re preparing, I’d recommend using hands-on exercises to build a strong understanding of:

  1. Query and workload optimization
  2. Access control, especially RBAC and DAC
  3. Data loading and unloading and sharing

I passed this week with a score of 880. Thanks to everyone in this community who shared their knowledge!


r/snowflake • • 4h ago

Consultants / platform leads: how do you build monthly cost reports and next-year budget forecasts for clients or finance across Snowflake + Fivetran + dbt?

Thumbnail reddit.com
1 Upvotes

r/snowflake • • 1d ago

Consultants / platform leads: how do you build monthly cost reports and next-year budget forecasts for clients or finance across Snowflake + Fivetran + dbt?

9 Upvotes

Spreadsheet? SELECT? Custom dashboards? How long does it take each month? Any ideas ?


r/snowflake • • 1d ago

How do you enforce naming conventions on Snowflake objects created outside dbt?

2 Upvotes

Our dbt models follow naming and type rules, but a lot of objects are created outside dbt: Fivetran tables, manual tables, old views, and objects from migrations. Over time we get mixed naming (CUST_NM vs customer_name), dates stored as VARCHAR, and the same column with different types in different tables.

How does your team handle this?

  • Do you use a tool for it?
  • Custom scripts on INFORMATION_SCHEMA?
  • Or do you just live with it?

Also curious if anyone does the same on Databricks / Unity Catalog.


r/snowflake • • 1d ago

How do you enforce naming conventions on Snowflake objects created outside dbt?

2 Upvotes

Our dbt models follow naming and type rules, but a lot of objects are created outside dbt: Fivetran tables, manual tables, old views, and objects from migrations. Over time we get mixed naming (CUST_NM vs customer_name), dates stored as VARCHAR, and the same column with different types in different tables.

How does your team handle this?

  • Do you use a tool for it?
  • Custom scripts on INFORMATION_SCHEMA?
  • Or do you just live with it?

Also curious if anyone does the same on Databricks / Unity Catalog.


r/snowflake • • 1d ago

Pulumi + Sqitch = Snow mgmt

Thumbnail reddit.com
1 Upvotes

r/snowflake • • 2d ago

Why should I use CoCo when I have Claude Code?

45 Upvotes

r/snowflake • • 1d ago

Pulumi + Sqitch = Snow mgmt

0 Upvotes

Snowflake Object Management Strategy for 2026
For 2026, I believe we have a very good toolset in place to manage Snowflake objects efficiently, with a clear separation of responsibilities:
Pulumi instead of Terraform: Pulumi should be our standard tool for managing all account-level objects in Snowflake using a CI/CD workflow based on plan and apply similar to the Terraform workflow we are familiar with.
Sqitch instead of DCM: Sqitch should be our standard tool for managing database- and schema-level objects, including tables, views, tasks, streams, and other schema-related objects. It also provides a CI/CD workflow with plan and apply directly within Snowflake.
Although Snowflake also offers the new DCM feature, I believe we should standardize on Sqitch for schema-level object management for all databases used in company rather than introducing another tool


r/snowflake • • 2d ago

Passed Snowpro Core Certification (COF-C03)

29 Upvotes

Sharing my experience on passing the SnowPro Core Certification as it is still fresh out of memory.

Background: I used Snowflake only for a few months for my current project at work.

Preparation: There were not a lot of resources and sample questions. What I went through was Nikolai’s Udemy course and practice exams. I felt that it was still not sufficient, so I kept checking my knowledge against ChatGPT and Claude. When I was preparing I was also doubting whether I was reading up on the right topics and concepts.

Exam experience: Most if not all of the questions were scenario based questions and the answers were closely related - takes time to read and decipher the correct answer. I took up the entire duration of the exam.

Questions: Questions mainly were mixed - I didn’t have much on QAS, but some on SOS. Transient vs. temporary tables. Some Data sharing questions e.g. if consumer same region, how to share or if a role in the consumer side wants to use then what should you do. A lot on optimisation, if query is slow what should you check first. Scaling of virtual warehouses, caching, grants. Semi-structured data, parse_json, querying them. Agreed with the rest that the AI questions were the easiest. COPY INTO concepts are important as well. Snowpipe, streams, tasks. Nothing much on time travel, failsafe, network policies architecture appearing for my test.


r/snowflake • • 1d ago

Do you guys use OS models like kimi for CoCo, does that save on coco costs?

1 Upvotes

Trying to save myself some money coco bill is going vertical.


r/snowflake • • 2d ago

I built a penguin video to show you what's new in CoCo Desktop

25 Upvotes

Hello hello, I'm Luke from the Snowflake CoCo team and we just shipped a GIANT update for CoCo Desktop and I love fun animations, so I made one to show you what we've built.

If you don't wanna watch, heres a quick TLDR:

→ Split panes: run multiple agents side by side
→ Agentic browserupgrade: CoCo tests your apps for you
→ Artifacts: share reports with your team by role
→ Cloud Automations: CoCo keeps working when your laptop is closed

Plus a full UX redesign (with much more coco penguin lol🐧).

Lmk what you think, hope you like the video 😸 (which I made every single part with CoCo too)


r/snowflake • • 2d ago

Which AI architecture to pursue having fabric and snowflake

8 Upvotes

Hi,

The company I work at recently purchased snowflake and want it to be the location of the data warehouse. At the same time we already had fabric F64.

I am interested in what is the best way to go down the AI road. Is it semantic views + cortex analysts. Which I prefer but it has its limitations in implementing complex measures.

Or go down the copilot road with data agents in fabric. I found then to be really limited and mostly descriptive. Maybe I’m wrong but in order to wire in additional context we might need to purchase Azure open AI and bind a data agent in there. I don’t really like it or want to go down that path.

Or do both. Maintain the semantics in both layers. Not great but we need the reporting for now. It does seem like a hassle going this way.

Do you guys have experiences along these lines.


r/snowflake • • 2d ago

Sign on: Something went wrong

2 Upvotes

Anyone else getting hit with this? We’ve been wanting to look into Snowflake as our DWH. Went to create an Enterprise account and got hit with: “Something went wrong: your account wasn’t created”

No easy recourse. Reached out to support / sales (?). And some guy asked me to set up a time with him. I don’t want to do that! I just want to create an account 😭


r/snowflake • • 3d ago

CoCo Desktop V2

10 Upvotes

[I work for Snowflake but don't speak for them.]

Massive update to CoCo Desktop just dropped. I use it every day heavily, so I'm always a little nervous that changes will take a while for me to absorb. But in this case, excellent release especially session search and server-side memory. Highlights:

  • A redesigned Desktop UI (generally available): A new layout for agent sessions, navigation and settings.
  • Multi-task with split panes (GA): Show several agent sessions side by side in one window.
  • Rebuilt agentic browser (GA): Tabs, page comments and agent activity indicators in the built-in browser.
  • Session search (GA): Find earlier sessions and reopen them.
  • Snowflake App Runtime support (public preview): Build, run, deploy and share Snowflake App Runtime apps, alongside Streamlit in Snowflake apps, from the Apps view.
  • Artifacts (public preview): Publish reports to Snowflake, share them by role.
  • Cloud automations (public preview): Scheduled checks and reports that run in Snowflake, including when your computer is off.
  • Agent profiles (public preview): A default model and set of skills that administrators define once for a team.
  • Server-side memory (public preview): CoCo's memory of your projects, stored in Snowflake and available on any machine.

Snowflake blog discussing the release:

https://www.snowflake.com/en/blog/engineering/what-s-new-in-coco-desktop-from-finding-a-data-issue-to-shipping-the-fix/

Docs and Download Links:
https://docs.snowflake.com/en/user-guide/cortex-code/cortex-code-desktop

Release Notes:
https://docs.snowflake.com/en/user-guide/cortex-code/cortex-code-desktop/release-notes

Highly recommend downloading the update!


r/snowflake • • 2d ago

PSA: check auto_stop_mins on your SQL warehouses if you deploy with bundles

0 Upvotes

If you create SQL warehouses through Declarative Automation Bundles and leave out auto_stop_mins, the default isn’t what you get in the UI. Bundles default to 10 minutes for Serverless and 120 for Pro/Classic. The UI defaults to 10 for Serverless and 45 for Pro/Classic.

Apparently someone deployed a Serverless warehouse with a bundle, didn’t set the field, and got 120 minutes instead of the 10 the docs list. That hurts if you have a bunch of short scheduled alerts, because each one wakes the warehouse up and then it just sits there until auto-stop kicks in.

A few other things from the same writeup:

The Serverless UI won’t go below 5 min auto-stop, but the API, CLI and bundles accept 1 (databricks warehouses edit <id> --auto-stop-mins 1). Pro and Classic bottom out at 10.

A single slow or spilling query points to warehouse size. Queries waiting at capacity point to max clusters. Peak queued queries above zero doesn’t tell you which one on its own.

Power BI DirectQuery can send a query on every dashboard interaction. If the business only needs fresh data every few minutes, Import or Hybrid mode cuts a lot of that.

DBU rate alone is misleading. In one AWS US East example, Serverless is about $0.70/DBU, Pro $0.55 and Classic $0.22, but Pro and Classic bill infrastructure on top.

Is anyone running a 1-minute auto-stop on serverless for scheduled jobs? Do the cold starts bother you?


r/snowflake • • 3d ago

Snowflake bill kept climbing while our warehouse credits stayed flat

7 Upvotes

Our cost dashboard is built on WAREHOUSE_METERING_HISTORY and it has sat around 2,100 credits a month for a while now. The invoice kept going up anyway and finance wanted to know why the two numbers don’t match.

Grouping METERING_HISTORY by service_type answered it in one query. Here’s one billing period, top lines only

WAREHOUSE_METERING      2,140
AUTO_CLUSTERING           610
SEARCH_OPTIMIZATION       240
PIPE                       95
MATERIALIZED_VIEW          60

Everything under the first line was invisible to us because the dashboard only ever read the warehouse view.

The clustering credits were one table. AUTOMATIC_CLUSTERING_HISTORY had our events table reclustering a few hundred million rows a day. Our dbt guy had switched the model from append to delete+insert with a three day lookback, so every hourly run rewrites three days of partitions and the clustering service re-sorts them right behind it.

The search optimizations was on two columns of a table that used to feed a support lookup dashboard. The dashboard got retired and the SOS just stayed on. That one’s off now but the clustering one is still up for debate with him because he wants the lookback for late events.

Right now, i only see clustering credits when I run this for finance. Does your team have an alert for them per table?


r/snowflake • • 3d ago

Are the skills that coco ships with easily available for other agents?

6 Upvotes

Like the title suggests, I like the skills that coco maintains, but I'm unable to easily use them in other coding agents.

Am I just unable to find them online, because I see its becoming an industry standard for companies to share their skills on github.


r/snowflake • • 3d ago

CoCo initial context size

5 Upvotes

I’ve just started looking at using CoCo in VS code and one thing I noticed was that after a single simple prompt, context usage was already over 100k. Is this normal and is there a way to reduce it? I know there is code mode but that seemingly disables the ability to use skills.

I’m not an expert in this area but I’ve watched videos of people using Claude Code and their context can start as low as 20k.


r/snowflake • • 4d ago

Having trouble setting up Claude at an organizational level to connect to Snowflake

4 Upvotes

I was able to connect my org's Claude account to our Snowflake account, but realized it was just for me with all the Oauth configuration.

How exactly do I or should I setup Claude and Snowflake so that any Claude user can ask questions against Snowflake objects? I know this is dangerous but I'll be giving access to just one sandbox schema that has just 1 table for now. This is beside the point of the post as well, and I've thought through this part of the process.

I was thinking of creating a service account on Snowflake, but don't remember anywhere on the Claude side of creating a Snowflake connector to designate a private key. Whenever I or a coworker has tested our current Claude-Snowflake connection, we're prompted to login to Snowflake. I did see this guide and a few others that instruct setting up Oauth.. Is there a way to avoid having every Claude user to login? We have several Claude users who don't have Snowflake accounts


r/snowflake • • 4d ago

I am looking for 1:1 Snowflake + DBT+Github training with job support. If anyone is interested, DM me. Thank you

0 Upvotes

r/snowflake • • 6d ago

Snowflake Engineering Manager Interview – System Design + Coding Experience?

9 Upvotes

Hi everyone!

Has anyone recently interviewed for an Engineering Manager (EM) position at Snowflake?

I'm particularly interested in hearing about the System Design with Coding Elements interview. According to the interview preparation material, it's structured as follows:

  • 30–35 minutes: System Design
  • 10–15 minutes: Coding

I'm curious about a few things:

  1. What kind of coding problems should I expect in such a short 10–15-minute window? Is it a small implementation task, writing a specific algorithm, or adding coding elements to the system design?
  2. How deep does the coding portion go? Should I expect LeetCode-style questions or more practical, real-world coding?
  3. What system design questions have you encountered?
  4. Are there any specific topics, concepts, or resources you'd recommend focusing on to prepare for this interview?

I'd especially appreciate hearing from anyone who has recently gone through this interview loop for an EM role.

Thanks in advance! Any insights or experiences would be greatly appreciated.


r/snowflake • • 5d ago

Design masking policy

1 Upvotes

Hi,

We have around ~7 data protection tags defined (PI, Confidential, Internal, etc.)defined. Each tag has about 14 type-specific masking policies attached based on the data types (VARCHAR, NUMBER, TIMESTAMP,BOOLEAN, DATE …), something as below. So total 12*7=84 masking policies defined. The policies use simple IS_ROLE_IN_SESSION() checks. Each column of the table is tagged with one of these Data protection tags or DPG tags.

When any use onboarded, they need to request for certain DPG functional roles whih they are entitled to and that goes through approval flow once that is approved , they are onboarded and each of their query has to go through these policy evaluation based on which they will be able to see/unsee the column data in a table.

Want to understand , if this is the standard data protection architecture people follow in real world applications?

Secondly , We see manytimes the queries suffer from poor pruning and estimates because of the masking policy wrapped around the columns , so in such scenarios some of the team mates suggesting , we should rather follwo a View approach, in which,

  1. The view will be created on top of the base table and the access to the end users should be given to the views but not on the base table. Only application functional role will be given access to the base table.

Or else

Masking policies should be defined on top of the views but not on the base table , so that application functional queries can get rid of the masking policy related performance overhead due to bad pruning as they will have direct access to the base table. Only end users access will be given to the views. Is this the approach advisable?

CREATE OR REPLACE MASKING POLICY CNFD_mask_string
    AS (val VARCHAR) RETURNS VARCHAR ->
    CASE  WHEN  IS_ROLE_IN_SESSION('DPG_CNFD_FR') THEN val    ELSE '***MASKED***'  END;
CREATE OR REPLACE MASKING POLICY HICNFD_mask_string
    AS (val VARCHAR) RETURNS VARCHAR ->
    CASE WHEN  IS_ROLE_IN_SESSION('DPG_HICNFD_FR') THEN val    ELSE '***MASKED***'   END;
CREATE OR REPLACE MASKING POLICY CNFD_mask_number
    AS (val NUMBER) RETURNS NUMBER ->
    CASE WHEN IS_ROLE_IN_SESSION('DPG_CNFD_FR') THEN val  ELSE NULL END;
CREATE OR REPLACE MASKING POLICY HICNFD_mask_number
    AS (val NUMBER) RETURNS NUMBER ->
    CASE WHEN IS_ROLE_IN_SESSION('DPG_HICNFD_FR') THEN val  ELSE NULL    END;

r/snowflake • • 6d ago

Has anyone given/taken a Snowflake CoCo/Cortex Code live coding interview?

4 Upvotes

I have an interview coming up tomorrow and it will have a live coding session where I am supposed to work with Cortex Code. Does anybody know what interviewers are expecting in these type of interviews. If you're senior architect and you're given the responsibility of conducting a live coding session, what would you look for in candidates?


r/snowflake • • 6d ago

Inside Apache Iceberg V3: Deletion Vectors and Puffin Files

Post image
14 Upvotes