u/mleb_mleb_mleb

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.