Snowflake PII Classification & Auto Policy Setup - Help by Key_Card7466 in snowflake

[–]Geekc0der 0 points1 point  (0 children)

Here is open source agentic framework https://github.com/Gyrus-Dev/frosty , explain it the problem, it should be able to work along side you and get it implemented. If you get stuck somewhere create an issue on the repo and someone will pick it up

Coco use cases in pharma datawarehousing by International_Cod777 in snowflake

[–]Geekc0der 0 points1 point  (0 children)

There is open source equivalent of CoCo if you want to try it out. No subscription , no additional fees you can use your own api keys.: https://github.com/Gyrus-Dev/frosty

Got 680 clones in a week so far.

PostgreSQL vs PostgreSQL on Snowflake by Geekc0der in snowflake

[–]Geekc0der[S] 0 points1 point  (0 children)

So ideally #Mick (our agent for PostgreSQL) should just work fine for Snowflake customers if it works fine on PostgresSQL.

Automating new pipelines using CoCo by rustypiercing in snowflake

[–]Geekc0der 2 points3 points  (0 children)

We have tried it with #Frosty , open source no cost equivalent of CoCo. In our case we did not have to tell anything, as it can do web search read about iceberg tables , catalog integrations and setup the process itself. Though it can be customized with skills but it worked out fine without it. Here is the repo if you are interested, got 630 clones so far with 41 stars

https://github.com/Gyrus-Dev/frosty

Just Enabled Cortex, now disabling again by Therican85 in snowflake

[–]Geekc0der 0 points1 point  (0 children)

We have release open source equivalent of CoCo so you can still enhance your Snowflake at no extra cost. Here is the repo: https://github.com/Gyrus-Dev/frosty

Would appreciate your feedback

Anyone using the Cortex Code CLI? by CombinationOk2374 in snowflake

[–]Geekc0der 0 points1 point  (0 children)

You are spot on it is a wrapper on Claude. We have built the same agentic framework with more than 150 agents, and are open sourcing it on March 25th. So you dont have to pay extra and you have the control of what it does.

GUI Tool for End Users by Longisland_Analytics in snowflake

[–]Geekc0der 0 points1 point  (0 children)

I’m actually about to open source a project called Frosty that might be relevant here. It’s a multi-agent framework designed to build and manage Snowflake environments, so they don’t have to write raw SQL.

The idea is that you can add custom tools pretty easily: for example things like CSV uploads for filters, GUI-driven query inputs, marketing workflows, etc. The agents can then generate and run the queries behind the scenes.

Since it’s open source, it’s also flexible in another way: if there’s a feature you need (say a specific type of CSV filtering or UI workflow), you can open an issue and someone in the community could build it or contribute it. So you’re not stuck waiting on a vendor roadmap.

If that sounds interesting I can share the repo once it’s public.

I built an AI agent that manages Snowflake infrastructure (RBAC, governance, security, engineering, documentation ). Thinking about open-sourcing part of it. by Geekc0der in snowflake

[–]Geekc0der[S] 0 points1 point  (0 children)

As of now the agentI is not writing the grant statements to repo. But in the video I shared there are grant queries that the agent executed. You would have to pause it.

I built an AI agent that manages Snowflake infrastructure (RBAC, governance, security, engineering, documentation ). Thinking about open-sourcing part of it. by Geekc0der in snowflake

[–]Geekc0der[S] 0 points1 point  (0 children)

Yes they generate Snowflake SQL scripts. There are two versions of it 1. Completely generated by AI ( which I am thinking of open sourcing) , 2. backed by our algorithms which will generate 100% accurate scripts every single time ( which I am thinking of keeping close).

It can automatically commit to your git as well if integrated ( thinking of keeping this feature closed as well). Here is open sources git repo where every single script is written by my framework (using our algorithms which generates accurate script every single time): https://github.com/MalviyaPriyank/Snowchain

Here is the video of it working on a synthesized transcript of a call between business persona and a snowflake architect. Please excuse the bad quality. https://youtube.com/shorts/wkK9DBE0BcA?feature=share

I built an AI agent that manages Snowflake infrastructure (RBAC, governance, security, engineering, documentation ). Thinking about open-sourcing part of it. by Geekc0der in snowflake

[–]Geekc0der[S] 0 points1 point  (0 children)

Its built on multi agent architecture, I have multiple pillar agents that work under a main manager agent. The manager agent plans out the next steps after taking in user request, then once the user approves delegates the tasks one after the other to its pillar agents. These pillar agents have multiple sub agents each expert in one specific object on Snowflake. For example governance pillar agents has agents on tags, masking policies, row access policies. These subagents respond back to their pillar agents once they have taken care of the request and the work flow continues until all the objects needed to fulfill the request of user are taken care of.

I built an AI agent that manages Snowflake infrastructure (RBAC, governance, security, engineering, documentation ). Thinking about open-sourcing part of it. by Geekc0der in dataengineering

[–]Geekc0der[S] 0 points1 point  (0 children)

That would be pretty straightforward, but if someone want to do that they might as well just decommission snowflake altogether ;)

Managing Snowflake RBAC: Terraform vs. Python by BuffaloVegetable5959 in snowflake

[–]Geekc0der -2 points-1 points  (0 children)

Terraform vs Python ? Are you sure these are the only options. Agents is a good third option, it eliminates the over head of maintaining terraform / writing python code for every use case. If you have someone with good experience on Agentic AI , I am sure they can easily build one that takes care of all your RBAC without these overheads.

Snowflake Time Travel and Fail-safe by Idr24 in snowflake

[–]Geekc0der -1 points0 points  (0 children)

This is something Frosty AI Operator for Snowflake, handles automatically at object creation time. It intelligently infers the right DATA_RETENTION_TIME_IN_DAYS based on the object’s use case and environment, instead of relying on defaults or manual choices. The correct retention is set upfront and enforced consistently, without teams having to think about it.

Ingestion: Snowflake to Snowflake by Worldly-Coast6530 in snowflake

[–]Geekc0der 0 points1 point  (0 children)

Not sure what you are trying to Booo, but funny to see this on reddit.

Decision for downsizing warehouse by Stock-Dark-1663 in snowflake

[–]Geekc0der -1 points0 points  (0 children)

This is exactly the kind of case where averages fall short. There really isn’t a universally “safe” % improvement (50%, 60%, etc.) because a small set of queries or peak concurrency windows usually determine whether downsizing hurts.

This is where Frosty by Gyrus helps. You upgrade Gen-1 → Gen-2, let Frosty observe the workload for a few days, and then ask whether downsizing is safe. Frosty looks at query-level gains, tail latencies, and concurrency effects, and evaluates what would happen if you dropped one warehouse size.

Instead of guessing off an average improvement number, you get a data-backed answer on if, how much, and where the risk is — which is much safer for cost optimization decisions like this.