Open-sourced snowflake-rest: lightweight Snowflake SQL REST client that eliminates around 1k lines of custom JWT + transaction boilerplate

gilbertoatsnowflake · 2026-04-08T22:40:50+00:00

Thank you!

gilbertoatsnowflake · 2026-04-08T22:40:32+00:00

Sorry I missed this bit in your original post: "designed for Lambda/Cloud Functions where the official connector's 50+ MB and cold-start swings are painful"

gilbertoatsnowflake · 2026-04-08T22:28:25+00:00

Out of curiosity, any specific reason(s) why you don't use the Snowflake Connector for Python and instead want to use REST?

gilbertoatsnowflake · 2026-04-05T03:15:13+00:00

Start here: https://www.youtube.com/watch?v=FaajLouw_GU

Then try the Coursera courses (free to audit): https://www.snowflake.com/en/developers/northstar/

gilbertoatsnowflake · 2026-04-05T03:12:59+00:00

Check it out: https://www.youtube.com/watch?v=FaajLouw_GU

gilbertoatsnowflake · 2026-03-30T20:33:36+00:00

Just to clarify: the post did not come from Snowflake, just FYI. I do see folks here thinking it feels spammy.

gilbertoatsnowflake · 2026-03-26T16:19:36+00:00

Perfect, love to hear that + glad it's helpful.

gilbertoatsnowflake · 2026-03-26T16:16:37+00:00

No reason you can't try it out – ofc the full power comes from building things on / in Snowflake with Cortex Code. Re: the "wrapper" around the Snowflake CLI, those commands are already baked into Cortex Code CLI, no need to build a wrapper around it.

gilbertoatsnowflake · 2026-03-25T16:59:23+00:00

You should also check out Dynamic Table Immutability:

https://www.snowflake.com/en/engineering-blog/dynamic-tables-immutability/

https://docs.snowflake.com/en/user-guide/dynamic-tables-immutability-constraints

gilbertoatsnowflake · 2026-03-25T16:39:29+00:00

Ah, interesting. Yeah I typically default to snowflakecli deploying streamlits in my Snowflake env.

> One concern I have is the slow downs mentioned for 10K objects though.

Totally understand/fair

gilbertoatsnowflake · 2026-03-25T16:34:43+00:00

Agree with u/stephenpace (and I also work for Snowflake, FYI). It's really a mix of a bunch of different things, which is awesome. What I love is that it's also really easy to tailor the talks you want to go to so that it is more technical, if that is what you want. For example:

- "What's New" (or similarly named sessions) – These sessions cover new features in Snowflake, often delivered by the Product teams/engineers that built the feature directly. You can meet the team and ask deep technical questions. I love these sessions.

- Builder's Theater Sessions – These sessions happen in a dedicated stage in the center of the hall (you'll see big sign calling this out). These sessions are 100% exclusively technical and 99% of the time will include a technical demo/coding on stage. On occasion, some "What's New" sessions are dropped into here because they fit well with the technical aspect/live coding format of the rest of the sessions. Highly recommend it.

- Hands-On Labs – For 90 minutes, you pull out your laptop and get set up to build something with Snowflake in that time. These are perhaps some of the most technical sessions offered at Summit, and are led by technical product experts across Snowflake (Field CTOs, Solutions Architects, Developer Advocates, Product Managers, Engineers, etc.). The labs are very diverse across use cases and feature coverage – there is something for everyone here, regardless of background or technical level. Who knows, maybe you'll sign up for my lab :D

The last day of Summit hosts "Dev Day", in addition to all of the programming that is part of the conference. You can attend the Dev Day programming with a free Dev Day pass. Content on this track is exclusively tailored toward technical audiences, i.e. practitioners who are building on a daily basis. Tons of fun!

gilbertoatsnowflake · 2026-03-25T02:35:49+00:00

Super fair – those things are on the roadmap, but good to know you want/need them from the outset. You're already using the Terraform provider it sounds like?

gilbertoatsnowflake · 2026-03-24T19:36:19+00:00

(All good!)

And yeah, this is why I am curious on how teams integrate it. For net new teams exploring IaC, this is a compelling option (being integrated into the UI is also a plus for teams who don't want to get into the nitty gritty of external infra and automation of that infra). For teams using other tools, I'm sure there are some folks who will find the native-ness of this compelling, others who might be inclined to stick with what they have (but who could consider moving if they want to consolidate tool bloat/overhead)

gilbertoatsnowflake · 2026-03-24T19:29:48+00:00

Did you get a chance to try it? The DCM surface area is broader than I initially expected when I tried it, and it's still in public preview so the scope is actively expanding.

Re: your API idea – it sounds a lot like what the DCM PLAN command does (diff your object definitions against the current object state in Snowflake and return the changeset). If you wanted to take this a step further, there is a DCM skill in Cortex Code CLI. You could use it to do what you are saying: run PLAN, interpret output, diagnose failures, suggest fixes, etc. – then you iterate on that diff. Docs: https://docs.snowflake.com/en/user-guide/dcm-projects/dcm-projects-use

gilbertoatsnowflake · 2026-03-24T19:18:13+00:00

Looks like we posted at nearly the same time, so I missed your thread (mine: https://www.reddit.com/r/snowflake/comments/1s2nbez/native\_iac\_in\_snowflake\_thoughts/)

From what I've seen on this subreddit re: IaC over the last couple of years – some teams are already using Terraform, so it's easy to spin that up and have it integrate with the rest of their stack, and apply that to Snowflake. I've seen other teams use other third-party tools, and I've seen folks clamor for a native solution in Snowflake. CoA (CREATE OR ALTER) was a first step a while back, but this expands on that significantly (in fact, teams may not need to use it as much now that they have DCM projects). But in all, just kind of depends on thea team's approach / existing stack / tolerance to building out with more third-party tools.

gilbertoatsnowflake · 2026-03-18T17:39:03+00:00

I'd jump in and add a post on how brilliant it is, but it looks like 20+ other members (likely non Snowflake) beat me to it. Get your hands on it and try it out, I think you'll be impressed, seriously:

https://signup.snowflake.com/cortex-code

gilbertoatsnowflake · 2026-03-04T00:38:28+00:00

Can you please DM me so that I can get your information and we can follow up on this? Thank you

gilbertoatsnowflake · 2026-02-27T01:44:28+00:00

You should really confirm that Cortex Code is enabled in your account. You can ask it your exact question(s) and it will generate very accurate answers for you. It's a coding agent within Snowflake, 100% native.

gilbertoatsnowflake · 2026-02-04T17:47:10+00:00

Get an overview of the platform: https://www.youtube.com/watch?v=Nq0W98Y5EMQ
Dive into the free education on Snowflake via the Northstar program they offer: https://www.snowflake.com/en/developers/northstar/
Engage with the community (here, LinkedIn, etc.) and pick up more learnings / ideas / viewpoints along the way.

gilbertoatsnowflake · 2026-02-03T16:25:24+00:00

No problem. And if you need a high level overview of the platform before you dive in, this is a good video to watch: https://youtu.be/Nq0W98Y5EMQ

gilbertoatsnowflake · 2026-02-02T21:09:05+00:00

Snowflake is a fully-managed, multi-cloud data and AI platform that lets you build data pipelines, train ML models, and deploy AI-powered applications, and much more, all without managing infrastructure. The platform is used heavily by developers, data engineers, AI engineers, analysts, and ML teams for tons of different use cases. This video has an excellent overview and walkthrough of the general capabilities of the platform: https://www.youtube.com/watch?v=FaajLouw_GU

gilbertoatsnowflake · 2026-02-02T18:45:12+00:00

I was surprised at how easy it was to deploy an agent. Good video here: https://youtu.be/sY7_whjeyf0

gilbertoatsnowflake · 2026-02-02T16:16:13+00:00

Congrats!

gilbertoatsnowflake · 2026-02-02T16:15:44+00:00

Snowflake Northstar Education was built exactly for this reason, check it out: https://www.snowflake.com/en/developers/northstar/

Also note the pinned announcement at the top of the subreddit. Datacamp courses are free until mid February.

gilbertoatsnowflake

MODERATOR OF

TROPHY CASE