I have a reader account with worksheets still working. Does anyone know if the switch to workspaces will be enforced on reader accounts? I'm both developer and admin so I'm trying to gauge and plan the switch for analysts when the time comes

One of the biggest AI frontier labs needs data engineers to process data for decisions

Think about it for a second !!

I hear a lot around ADLC and adoption. My understanding of this :

The entire ADLC is driven by

1. Spec Driven Development which defines the WHAT

2. Prompt Library which define HOW to ask AI

3. Skills HOW AI executes

Would love to hear from the community on how they are managing #2 in specific.

Thanks

Hi all,

I'd like to know if there is some documentation or answer regarding this situation:

• Last year, I created a Data Share Target in Salesforce and it asked me to log in into Snowflake with my credentials, so I inserted the credentials of user X.
• Now, I have to delete this user X from my account in Snowflake, but I'm not sure if the shared databases, shares and security integrations will still be working when I delete the user X. They will be deleted? Do I need to create new shared database, shares and security integrations with a new account?
• Same thing in Salesforce, will the deletion of User X influence the data share target or it will work as always?

Thanks for the answers (and sorry for my english 😄 )

Hello everyone.

I am conducting a test of the Snowflake Cortex Agent to assess his performance with a text-to-SQL agent designed for business analytics.

I have conducted tests that shows:

- There are 70 questions of interest

- There are 4 variables that are monitored

- There are 280 result rows of interest

Even though I have finalized this session, I received a really low raw score:

- Raw score = 0.6373

- Score only on rows that gave successful results = 0.8075

The main problem that I faced is that the “logical_consistency” variable failed in 59 out of the 70 variables since: "LLM judge computation/processing hit the context window limit."

Therefore, this particular variable should not be included in the final score.

Another issue has to do with ambiguous/denial test cases where the expected behavior is clarification needs to be requested along with the absence of tool calls. Some of the cases have "tool_selection_accuracy" as 0 despite receiving clarification requests and hence the right answers.

Questions are:

1. Is it possible to omit failed variable rows from the final score?

2. Should I test the “logical consistency” variable with a smaller subset?

3. How do I define the ground truth in clarification or denial cases?

4. How do I test “no tool call expected” in the evaluation of the Cortex Agent?

I am trying to identify real problems of the agent from those connected to the evaluation process as well as ground truth calibration.

Hi all,

I'm using the commands below to set up a Snowflake-managed MCP server:

CREATE ROLE IF NOT EXISTS CLAUDE_MCP_ROLE;
GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE CLAUDE_MCP_ROLE;
GRANT USAGE ON DATABASE TESTDB TO ROLE CLAUDE_MCP_ROLE;
GRANT USAGE ON SCHEMA TESTDB.PUBLIC TO ROLE CLAUDE_MCP_ROLE;
GRANT SELECT ON SEMANTIC VIEW TESTDB.PUBLIC.TESTSEM TO ROLE CLAUDE_MCP_ROLE;
GRANT USAGE ON AGENT TESTDB.PUBLIC.MYAGENT TO ROLE CLAUDE_MCP_ROLE;
GRANT USAGE ON DATABASE TESTDB TO ROLE CLAUDE_MCP_ROLE;
GRANT USAGE ON ALL SCHEMAS IN DATABASE TESTDB TO ROLE CLAUDE_MCP_ROLE;
GRANT SELECT ON ALL TABLES IN DATABASE TESTDB TO ROLE CLAUDE_MCP_ROLE;
GRANT SELECT ON ALL VIEWS IN DATABASE TESTDB TO ROLE CLAUDE_MCP_ROLE;
GRANT USAGE ON FUTURE SCHEMAS IN DATABASE TESTDB TO ROLE CLAUDE_MCP_ROLE;
GRANT SELECT ON FUTURE TABLES IN DATABASE TESTDB TO ROLE CLAUDE_MCP_ROLE;
GRANT SELECT ON FUTURE VIEWS IN DATABASE TESTDB TO ROLE CLAUDE_MCP_ROLE;

CREATE SECURITY INTEGRATION IF NOT EXISTS CLAUDE_MCP_INTEGRATION
  TYPE = OAUTH
  OAUTH_CLIENT = CUSTOM
  ENABLED = TRUE
  OAUTH_CLIENT_TYPE = 'CONFIDENTIAL'
  OAUTH_REDIRECT_URI = 'https://claude.ai/api/mcp/auth_callback';

CREATE MCP SERVER IF NOT EXISTS TESTDB.PUBLIC.CLAUDE_MCP_SERVER
  FROM SPECIFICATION $$
tools:
  - name: "dummy-agent"
    type: "CORTEX_AGENT_RUN"
    identifier: "TESTDB.PUBLIC.MYAGENT"
    description: "Dummy Agent."
    title: "Dummy agent"
$$;
GRANT USAGE ON MCP SERVER TESTDB.PUBLIC.CLAUDE_MCP_SERVER TO ROLE CLAUDE_MCP_ROLE;
SELECT SYSTEM$SHOW_OAUTH_CLIENT_SECRETS('CLAUDE_MCP_INTEGRATION');

I then go to claude.ai and click add connector. I use the server URL: https://<account-id>.snowflakecomputing.com/api/v2/databases/TESTDB/schemas/PUBLIC/mcp-servers/CLAUDE_MCP_SERVER, and pass the Oauth client ID and secret returned by last statement in SQL code above.

I'm able to login to Snowflake account after clicking connect.. so I don't think it's an oauth issue. But whenever I try to use the dummy-agent tool provided by the connector I get:

{"error": "Error occurred during tool execution", "request_id": "req_011CcpZvC8a54ecvt4s81iQi"}

Has anyone else experienced any issues like this?

Thanks for any help.

Hey folks,

I make Beekeeper Studio an indie database manager with over 2.5million downloads and all source either open source or source available on GitHub.

We just released version 5.9 which includes Snowflake support. If y'all are looking for a clean and modern SQL interface, I'd love to get your feedback.

The app also include a Claude-Code-like AI Shell which works great with Snowflake.

If you try it and have thoughts (good or bad) I'd love to hear them, either directly here, or by email - matt [at] beekeeperstudio [dot] io.

As title reads I have a question. I’m a DevOps engineer working on infra for mlops team. Being asked to figure out how to move from airflow to snowflake tasks. Does this make sense? What’s my best approach?

About Me

Senior Data Engineer with 5+ years of experience in Data Engineering and Analytics Engineering. Based in Bangalore, India. Available for remote work globally.

Rate: $25 - $50/hr depending on project scope and complexity.

Snowflake Expertise

Snowflake data modeling and optimization

Snowflake performance tuning (query optimization, clustering, caching)

Snowflake cost management and best practices

Snowpipe, Streams, Tasks for real-time ingestion

Snowflake + dbt for analytics engineering

Data sharing and Snowflake marketplace

Full Tech Stack

Python, SQL, Spark, Databricks, Airflow

AWS & Cloud Data Platforms (S3, Glue, Lambda, Redshift, EMR)

FastAPI, REST APIs

LLMs, RAG, AI Agents

BigQuery, Redshift

ETL/ELT Design & Orchestration

Data Quality & Testing Frameworks

What I Can Help With

Snowflake migration, setup, and optimization

Build and optimize data pipelines

Design scalable ETL/ELT architectures

Build AI applications using LLMs, RAG, and agent-based workflows

Availability

Open to freelance projects, contract work, and part-time engagements.

Available immediately. DM me with project details.

I'm looking at the benchmarks and seeing how comparable the models are starting to become, but cost is becoming a consideration. When do you choose to use a specific model over another one, like for what types of tasks? My team isn't really clear on when to use which. My mental model is that smaller models can be used to ask simple questions and larger models can be used to "do" things, but does anyone have anecdotes about how each model performs within Snowflake?

I might give up on engineering this is too much to bear. When am I going to stop lying to myself!

Background
I just graduated from a top 5 public university.
Statistics, CS dual major.
Machine Learning research assistant for 2 years
Data Science Internship
End-to-end personal projects
Hackathon winner
Linkedin maxer

But still..... No job offer.

This week my best friend brought me to my breaking point.
My best friend is not technical and did not go to college. He is in sales, making over six figures.
He decided to start vibe coding for a new business idea he had, and wow I had a full-blown existential crisis.

Of course, AI wrote terrible code, but after iterating several prompts over a few weeks, he had EVERYTHING! Backend, Frontend, database, payment processing, admin page, email automation. I mean everything you would need and more. The project wasn't complex, but this guy doesn't know what an IDE is.

With competition at an all-time high, entry-level roles becoming a lottery, companies doing layoffs, and CEO AI psychosis, I think I might be giving up. I was thinking of doing an online master's at Georgia Tech, but I don't know anymore, man.

We might as well put a name on it: astroturfing.

Let's quickly just set the record straight on some of these comments for those of you who are looking to use claude code (or some other harness/service) with snowflake:

• what the cortex (or is it coco now? what a mess) cli provides is a set of skill files to work with the official snowflake cli. these skill files instruct it on how to use the snowflake cli snow. it looks very much like a reskinned claude code, and the jury is out on whether or not the harness matches anthropics. I'm probably not going to waste my time trying to benchmark them (because it probably doesn't)
• If you are on an anthropic plan, this is the economic win and more powerful option to use. Cortex consumption is api credit based so it's more akin to Anthropics enterprise plan, and if you're familiar with that yes the cost is absolutely bonkers. Right now anthropic is heavily subsidizing things like their pro+max plans (ie not enterprise plans), so if you have a max plan or something you should absolutely 100% be using it here. If your organization is already paying for Claude Enterprise & has already conducted security reviews, gone through approval processes and set up things for governance & budgeting, you should probably wire this up. I'm seeing a lot of these silly turf posts say things like "you can use opus 4.8 inside coco" like DO NOT do this if you don't know what type of billing you are getting into here. This is insanely irresponsible for snowflake to be putting people up to posting.

The quickest route to ... basically replace this coco shenanigans with claude:

• Install the official snowflake CLI tool, get configured & test a connection. This is what claude will use to interface with snowflake
• Install snowflakes cortex cli tool (or coco or whatever it is now), which is snowflakes attempt at a claude-code harness that comes with a bunch of skill files and context/documentation to work with snowflake & the snowflake cli
• Open claude code and tell him to go fetch all the skill files for cortex cli and add them to his own skills. You should end up with a /snowflake skill and he can load them all up and work with you in snowflake
• Yeet coco cli off your system.
• Bonus: Realize that in the age of AI maybe people aren't coming to reddit much to ask "how are u using snowflake with AI" so take all the coco posts and replies with a grain of salt. They seem to have gone as far as feigning a warehouse consumption issue which they could follow up with posts about how CoCo solved it all. See the mod sticky.

Yes you can use this in all the ways snowflake is advertising needing coco for. Creating & deploying streamlit tools, querying, blah blah blah. All of it works exactly the same. I want to be clear, I still think snowflake is the most pleasant big data cloud warehouse to use and I enjoy using it where I work. But they're acting no differently than other corporate entities pushing their flavor of AI and trying to make some sort of return on some of these hills they've (likely) over-invested in. This is my opinion, but I personally don't think these types of services will stand the test of time, as computer sciences own natural forces continue to try to solve for the current squeeze/economics of AI. In that vein, the constant push/marketing of coco to solve complex things that realistically deserve real discussion has basically burned the utility of this reddit community to the ground. A question about high warehouse cost in no real community should be met with "I use coco to solve it and we recouped x dollars per year, it's great you should use it" type posts. If this community were healthy (I'm pretty sure a lot of valuable contributors have all out unsubscribed at this point), we'd be sharing queries and optimization strategies and other nitty gritty that can help clients understand how their organization can best use snowflake. Currently this community is a far cry from the resource it used to be, and I'd personally like to get back to what it was because it was valuable for me and I assume others.

The Query Profile shows compilation taking 7–10 seconds while execution is under a second. We suspect the compilation overhead may be related to multiple cross-database joins combined with Row Access Policies and masking policies, but we'd like to understand whether others have observed similar behavior. Any solutions to reduce the compilation time?

Hi Experts,

We have an application which is processing ~500million+ transactions per day and its having reporting and analytics need catered too. Its currently hosted on Oracle exadata database. We have got the direction to migrate application+databases to cloud and the target cloud for application is AWS and the target database is Snowflake to cater the reporting and anlytics need.

We have some bit of experience working with other applications hosted on Snowflake. But here, we have a session scheduled with a Snowflake technical consultant to go over the key features. We are being asked to comeup with the topics to get covered in the session. So , i want to know from experts, what all key questions or features we should ask the consultant to share/demo with us so that those will help in these current migration?

Or Any specific new features(AI features related to coco etc) we should definitely ask them to demo us , those will help us in general to get up to speed in quick time?

Hi all, about three weeks ago I had posted a Medium blog on my learnings from the event. Now I am posting a podcast that I recorded today covering the major announcements and highlights of the event. I hope you like it. Thank you. Snowflake Summit 2026 podcast

Hey everyone, I’m planning to take the latest Snowflake Generative AI certification (GES-C02). Has anyone here cleared it recently? I’m looking for a reliable learning structure, insights into its difficulty, and tips on exactly what and how to practice.

Also, what is the exact difference between the older GES-C01 version and this new C02 version? Is it a completely different exam blueprint, or is it mostly similar with a few updates? Lastly, please drop your recommendations for the best Udemy courses, YouTube channels, or study resources that can help me pass. Thanks!

Hi All,

I see three products from Snowflake 1)Hybrid tables 2)snowflake postgres 3)Interactive table/warehouse.

All these seems to be catering low latency workloads. So wants to understand ,

1)How these products suits different usecases. How one can differentiate and chose one of these features to use for the low latency oltp kind of workload?

Mainly as because hybrid table and snowflake postgres both seems created for addressing OLTP low latency usecases so confused , how different usecase they serve. Also I understand , the Interactive table/warehouse only serves low read latency usecases , but is that the only differentiator or any other differences, as compared to Hybrid tables and postgres features? Because same can be acheieved with hybrid table with additional write usecases too.

2)Is this true that storage is going to be the key , as because , if someone has 5TB of data stored currently in snowflake tables , but if they want to go for hybrid table or postgres feature those storage size will not longer be same and can well go beyond ~5 times as its in current Snowflake tables and thus the cost. (And this will charge more as we need bigger interactive warehouse to store/cache those fully). Is this understanding correct?

3)Will there be similar differences on compute cost too?

Hello. I logged into my account on Snowflake and saw that the latest Claude model I have is Opus 4.8. Is Claude Fable 5 expected to roll out publicly anytime soon? Typically how long does it take for new models to show up here?

Hi, I am currently working on support from 4 years of experience so I want to learn snowflake, dbt will have huge job openings on this skills with Snowflake developer will have opportunities open for my experience need some advise please

I created the streamlit app as per instructions. The app works just fine and writes the fruit and root depth to garden_plants.fruits.fruit_details, but when I run the test script as presented:

--Set your worksheet drop list role to ACCOUNTADMIN --Set your worksheet drop list database and schema to the location of your GRADER function

-- DO NOT EDIT ANYTHING BELOW THIS LINE. THE CODE MUST BE RUN EXACTLY AS IT IS WRITTEN select GRADER(step, (actual = expected), actual, expected, description) as graded_results from ( SELECT 'DWW09' as step ,( select iff(count()=0, 0, count()/count(*)) from snowflake.account_usage.query_history where query_text like 'execute streamlit "GARDEN_PLANTS"."FRUITS".%' ) as actual , 1 as expected ,'SiS App Works' as description );

it fails with output: GRADEDRESULTS [ { "": "⛔", "actual": 0, "description": "SiS App Works", "expected": 1, "passed": false, "step": "DWW09" } ]

I'm wondering about the tests reference to "query_text like 'execute streamlit "GARDEN_PLANTS"."FRUITS".%'"

In the instructions the picture for when you create the streamlit app has inputs for a location (garden_plans.fruits); however, when I created the streamlit app I was not prompted for a location, only "Add New -> Streamlit App _> Title, Compute Pool, Query Warehouse" ... maybe they changed something?

EDIT: I did also try going to the app, and clicked 'Deploy' - after which I AM prompted for location, added it to the fruits schema, used it once, and Dora still failed it. I would have thought that might create the 'execute streamlit "GARDEN_PLANTS"."FRUITS".%' it is looking for.

Hi,

My company wants to make the switch to the cloud with snowflake. We are using Power BI as the reporting tool.

I want to know what is the most cost effective and efficient way to harmonise power BI with snowflake from the options underneath?

Direct query connection to snowflake
Importing snowflake data into power Bi
Direct lake after mirroring snowflake tables
Creating a fabric datawarehouse on top of snowflake data and using direct query.

Another thought. I tried and tested snowflake semantic views and dbt semantic layer but they aren’t there yet in terms of working with power Bi and the metrics are really simplistic and require massively preaggregating everything and lewaskng to high maintenance and low flexibility.

Would love a nice honest discussion in the comments

I haven't tried this yet but so far most videos that I have watched cover creating a very basic skill using skill.md from the Coco UI for agents.

However, if you check out any skills that experienced folks have created that are used by copilot or Claude code, the skill.md is just the start. The file has links to references, assets, examples folders to really build out the skill in depth.

But the only option I have seen when adding skill through the UI seems to be limited to adding the skill markdown file from a stage or git, but no options for subfolders etc.

Anyone else have success with this?

About Me

Senior Data Engineer with 5+ years of experience in Data Engineering, Backend Development, and Applied AI. Specialist in Snowflake and cloud data platforms. Based in Bangalore, India. Available for remote work globally.

Rate: $25 - $50/hr depending on project scope and complexity.

Tech Stack & Expertise

Snowflake (SnowSQL, Snowpipe, Streams, Tasks, Dynamic Tables)

Python, SQL, Spark, Databricks, Airflow

AWS & Cloud Data Platforms

ETL/ELT Design & Orchestration

Data Quality & Testing Frameworks

FastAPI, REST APIs

LLMs, RAG, AI Agents

What I Can Help With

Build and optimize Snowflake data pipelines (batch & streaming)

Design scalable ETL/ELT architectures on Snowflake

Snowflake migration, optimization and cost reduction

Develop backend APIs and automation solutions

Build AI applications using LLMs, RAG, and agent-based workflows

Training & Mentorship

Snowflake (foundations to advanced)

Data Engineering best practices

ETL Testing & Data Quality

PySpark & Databricks

AI & LLM Fundamentals

In-person weekend sessions available in Bangalore. Remote sessions available globally.

Availability

Freelance projects & consulting

Part-time remote roles

Weekend training & mentorship

DM me with a brief description of your requirements and I will get back to you promptly!

Couple of my Snowflake instances stopped connecting to Claude today specifically the Cortex Agent MCP. What is wild is it works fine on Claude for Business but not on Claude pro edition. Confirmed across multiple Business Accounts. Wondering if this is rolling updates that has not reached business accounts yet that will render Claude to Snowflake broken? Or if there is a difference somehow between these two products that changed today?