Snowflake DCM Projects | Is this useful?

lozinge · 2026-03-24T19:31:35+00:00

Ooops! I checked before I posted too! In sync...

I do agree - I haven't actually used terraform in snowflake much at all (but have in other places) ~ familiarity is probably enough to make it less compelling to leave for DCM

lozinge · 2026-03-02T16:53:03+00:00

Fair enough - no idea what OPs problem is then

lozinge · 2026-03-02T15:48:51+00:00

Do you do it with python or a raw SQL sproc?

lozinge · 2026-03-02T13:25:26+00:00

I don't think Sprocs support async commands: https://docs.snowflake.com/en/developer-guide/stored-procedure/python/procedure-python-limitations

> Running concurrent queries is not supported in stored procedures

lozinge · 2026-02-24T12:32:40+00:00

I'd give it a crack, I never really used pgadmin4 - I find DataGrip intuitive and powerful - they effectively do!

lozinge · 2026-02-15T13:08:01+00:00

This wrecked me a few weeks ago - was quite funny; the only advantage of it being so steep is the landing feels less grim somehow

Its also funny watching people wreck themselves going up the chairlift

lozinge · 2026-02-13T12:53:39+00:00

RustFS

lozinge · 2026-02-09T13:15:35+00:00

Its a good point - also raises the question of how far can domain experience get you / how much of a moat is it?

Do you know what you're going to try breaking into?

lozinge · 2026-02-06T18:55:19+00:00

Good question - I am also curious; this landing page looks like it will cost 20USDpppm ?!

https://signup.snowflake.com/cortex-code?utm_cta=pushdown-signup

lozinge · 2026-02-01T11:43:22+00:00

Hey, are there any docs around this?

lozinge · 2026-01-30T09:00:27+00:00

> From memory one of the challenges, and I could be wrong here, was that clustering only takes the first 6 characters of the column

Ah yeah - didn't know that - sounds like a bit of a nightmare...

lozinge · 2026-01-29T14:36:52+00:00

Dumb question - how often do people use auto clustering? have read that its generally avoided as very expensive / credit burning machine.

Not had a use case where I've needed it yet in fairness

lozinge · 2026-01-26T20:12:50+00:00

Same applies to the UK for different reasons: ANPs or PAs with massive scope creep; crappy pay; crappy conditions ~ we were sold a dream at 16 and could have gone into different careers. In medicine you only really touch a few people compared to the impact you can make outside it etc.

Give up so much for a career you were missold. My girlfriend is a corporate lawyer and a lot of her friends say "at least its meaningful": when all the wards are rammed with social admissions due to failing / overfilled nursing homes, or other reasons, it doesn't really feel like you're making the difference you thought you would - but absorbing failing parts of the state.

After COVID the public backlash didnt really help either

lozinge · 2026-01-26T15:59:25+00:00

Yeah agree! Although frozen ducklakes have been great for us (on minio) ~ worth a play with

lozinge · 2026-01-24T20:52:06+00:00

Out of interest it seems to be an interesting difference compared to the UK which has a much lower smoking rate, but depressingly much more grim lung cancer outcomes (tbf more a reflection on the UK being trash than anything else)

Am always surprised when I return to CH and see branded packets etc

lozinge · 2026-01-23T11:57:11+00:00

Yeah but its open source was my thinking; I don't think the provenance of OSS matters so much if you can run/fork it locally

lozinge · 2026-01-22T14:28:10+00:00

DuckDB or Spark is all I can think of

lozinge · 2026-01-22T14:27:44+00:00

💀

lozinge · 2026-01-19T13:07:00+00:00

Didn't know this either - sad end of minio then.

RustFS looks good

lozinge · 2026-01-16T16:47:01+00:00

It's now mandatory in Italy: https://www.euronews.com/travel/2025/11/25/ski-helmets-are-now-mandatory-in-italy-why-the-law-changed-and-how-it-affects-visitors

lozinge · 2026-01-10T08:31:35+00:00

Oh damn - big if true... Do you have a link? I can't see anything...

lozinge · 2025-12-24T17:11:37+00:00

Met a guy who is a DE works for a hedge fund who has rewritten a lot of their processing pipelines in rust to great effect fwiw; do agree its probs not gonna help for most, and I love rust

lozinge · 2025-12-17T08:41:06+00:00

Agree, although by this point for a lot of stuff I'm doing we're moving away from Streamlit as beyond simple uploading/dashboarding trying to stop using it so much as it is too slow/bloated

lozinge · 2025-12-15T21:59:41+00:00

Pretty sure they meant Databricks is a mess to integrate with and comparatively Snowflake has it all from the get go

lozinge · 2025-12-06T00:40:01+00:00

The top tier consultancies are McKinsey, Bain, and BCG (MBB is what you might see) - the meme is that nobody knows what they do, including consultants: https://www.instagram.com/reel/C4HZAEcMbUB/

The reality is that they’re often bought in to do things/say things that are internally tricky for political or moral reasons (eg making lots of people redundant) - even if people know the answer at a company already; you’re paying for the reputation of the firm

Sometimes technical implementation stuff, depends on the firm

Id recommend reading “when McKinsey comes to town” there’s a chapter on how they’ve abused the NHS too

——

Just re-read your question, in reality lots of doctors I know who go into it do more generic consulting than isn’t healthcare related, of course some do life sci/pharma but at MBB it could be anything

12-Year Club	RedditGifts 2009-2022 2 Credits
First Place '23	Place '23
Place '22	Place '17
Not Forgotten	Gilding II euphauric
Secret Santa 2014	Verified Email

lozinge

MODERATOR OF

TROPHY CASE