r/snowflake

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. 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. 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?

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 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?

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

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: GRADED_RESULTS [ { "_": "⛔", "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 everyone,

I just started as a data engineer with basic knowledge of Snowflake. Currently, I'm on the bench at my company, and there's an upcoming project where they plan to implement Snowflake with dbt. I really want to grab this opportunity because otherwise I'm worried I could end up on the layoff list.

The problem is that the team expects developers to work using:

* Snowflake

* dbt Core (not dbt Cloud)

* VS Code (this is where they want to implement everything)

* Git

* Azure DevOps

* CI/CD pipelines

* Version control and branching

* Knowledge of deployment to higher environments using Devops

I've tried learning from YouTube, but most tutorials either:

* teach Snowflake only using Snowsight and not vs code or

* teach dbt using dbt Cloud.

I'm struggling to find an end-to-end tutorial that shows how these tools are actually used together in a real project. For example:

* How are CI/CD pipelines set up for snowflake+dbt?

* What does a real project folder structure look like in vs code?

I am reading documentation, but as a beginner I am getting confused and finding it complex. I learn much better through videos or hands-on walkthroughs. If anyone knows:

* a YouTube playlist,

* an online course,

* a GitHub repository,

* a blog series,

* or any mentor/content creator that covers this complete workflow,

I'd really appreciate it.

Even a roadmap of what to learn first would help a lot.

Thanks in advance!

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?

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 Pr. 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?

is there anyone using snowflake without dbt for data engineering? what are you using for your transformation logic?

I was recently contacted by a snowflake recruiter about applying for the solutions engineering role and I'm considering it. My main question for SEs is how is their work life balance and how much do they travel in general? I spoke with our orgs current SE and she told me she works a lot, like... It sounded like 60-80 hr weeks which doesn't sound appealing to me. That said, the benefits package and compensation seems really good. Are there any SEs here who can give me their opinion on this role at Snowflake?

My end users often want the resulting data sets to be in a PDF. Current Co-work experience only offers options to download the result set as a csv.

I'm trying to create a stored procedure that can be passed to the snowflake agent as a tool but haven't had success using coco or Claude code.

Not sure why the PDF fails to open.

Has anyone successfully created such a procedure?

Hi all,

I plan to take the new format of GEN AI. Just keen to know if anyone took it recently can share their experience? TA.

My company is evaluating which coding assistant license we should procure. Most of our development work is on Snowflake, but we don’t want to rely primarily on CoCo because the client is unlikely to agree to cover CoCo consumption costs.
Our plan is to use CoCo only for Cortex Agent/Analyst-related use cases and occasional tasks such as understanding column or table metadata—so overall usage would be minimal. For day-to-day coding and development, we’d prefer to use a different coding assistant.
Given this setup, which coding assistant would you recommend?

I also what to eventually be able to automate/ease repetitive tasks using skills or some other features

Give me your stories and recommendations please!

never used VSCode before. have been using snow sight.

any best and clear youtube video tutorials for learning VSCode to use snowflake, CoCo, python, Github in VSCode. Navigations videos. thanks.

First off, thanks to the 167 people who voted on my recent poll on who is using Streamlit in Snowflake! With nearly 60% of this sub actively building on Streamlit in Snowflake (SiS), it’s clearly shifted from a niche ad-hoc tool to something people are building production-grade data apps with.

However, as my internal data apps are starting to scale past simple tables and basic mockups, I'm hitting a major wall with UI layout and state management.

The second a business stakeholder requests a complex dashboard grid, side-by-side KPI metric placements, or advanced tab formatting, I feel like I'm wasting hours writing massive blocks of messy Python columns (st.columns), containers, and layout boilerplate just to position basic widgets.

Or constantly going over and over with AI prompts to nudge widgets around or fix layout states which feels incredibly inefficient and eats up a ton of token context when passing large scripts back and forth.

For those building heavy internal data apps on SiS, how are you handling UI/UX design? Are you just brute-forcing it with hardcoded layout arrays, or is there a cleaner design pattern/architecture I'm completely missing?

Has anyone else found Cortex Code to be expensive?

I set CORTEX_CODE_desktop_DAILY_EST_CREDIT_LIMIT_PER_USER to 15 credits/day (roughly a $25 daily limit), and I'm using Sonnet (not a more expensive model). Even then, I can burn through the entire daily budget in just a few debugging sessions. It feels like the credits disappear much faster than I expected.

For comparison, I have a $20/month Claude subscription, and I use it extensively for coding without ever worrying about hitting limits.

Am I missing something about how Cortex Code consumes credits? Are there best practices for reducing usage (prompting, context size, session management, model settings, etc.), or is this just the expected cost?

I'd really appreciate hearing how others are using Cortex Code in practice and what you've done to keep costs under control.

Bonjour à tous, j'essaye de me connecter à snowflake sur power bi mais je n'y arrive pas je ne sais pas si je me trompe d'url mais on me dis à l'étape de connexion avec mdp et username :"Nous n'avons pas pu authentifier avec les informations d'identification fournies. Réessayez" alors que c'est les bonnes informations.

Merci pour votre aide