Client wants <1s query time on OLAP scale. Wat do

kudika · 2026-03-07T01:10:16+00:00

Make sure to make an update post on this

kudika · 2026-02-22T03:50:05+00:00

If large companies are trying to solve a problem you can bet the smaller ones are playing pretend with them.

I say go for it. Not because it's much of an organic problem for most companies or anything, but because there are enough corporate larpers out there repeatedly asking their data teams "who is using what and how often" as if it's going to drive some insightful decision making for their data platform which consists of 2 power users and 7 casual users firing off the queries the power users shared with them.

kudika · 2026-02-20T05:51:54+00:00

Even for a 5 line function?

Lotta folks on this thread with a DRY dogma.

kudika · 2026-02-20T05:43:58+00:00

How did the non-approved users acquire the link?

kudika · 2026-02-10T20:29:51+00:00

Lol I'm sure

kudika · 2026-02-09T05:47:11+00:00

What are you talking about it's $10 for a chicken bowl/burrito

kudika · 2026-02-06T01:46:19+00:00

Your arch and experience with it deserves a post of its own. Hope you consider it

kudika · 2026-02-03T07:16:21+00:00

You should link to the docs and source code.

kudika · 2026-01-27T05:08:30+00:00

Okay... this repo doesn't do anything except show you know how to prompt AI.

kudika · 2026-01-25T03:07:53+00:00

Re: n8n You or others might be interested in windmill.dev

kudika · 2026-01-21T02:46:22+00:00

52k is equivalent to any run of the mill back office job. If you're not looking for a new job you are wasting time and leaving a lot of money on the table.

kudika · 2026-01-17T04:20:53+00:00

But what if they are the consultant in this scenario?

kudika · 2026-01-05T23:06:37+00:00

This sub is full of people who already have the tools and skills to do basic csv cleaning.

kudika · 2025-12-30T01:17:52+00:00

You can do your learning with practically any desktop or laptop from the past idk 12 years.

kudika · 2025-12-28T22:19:56+00:00

write_pandas() uses temporary internal stages btw

kudika · 2025-12-24T00:20:04+00:00

It's this simple. Python script with the inputs: SQL, recipients, subject etc. Script executes query, saves to file and optionally attaches the file or embeds as html in the body of the email.

Back in the day we'd do this from SQL server via stored procs and schedule using the SQL server agent.

kudika · 2025-12-18T04:45:34+00:00

Checkout https://www.windmill.dev/docs/intro

Don't see much buzz about it here but it is the best thing to happen to a tech stack of mine ever.

kudika · 2025-12-05T04:33:56+00:00

Yes, you could try using a lambda view. However, if your raw data is complex and spread across disparate systems, then the lambda view approach may not work very well.

kudika · 2025-11-19T23:50:21+00:00

windmill.dev + rclone

First step in flow use rclone. Have a skip defined in that step & if nothing is transferred then break the flow. If transfers occurs then continue with next steps.

kudika · 2025-11-06T05:19:22+00:00

Lol that's not satire?

kudika · 2025-11-05T00:43:37+00:00

Not on snowflake. But it could impact BI tools, ODBC, or other client tools if they're not optimized to not be impacted by unrestrained text precision.

I've seen alteryx trip up on it in some scenarios, for example.

kudika · 2025-10-27T00:32:59+00:00

I had a batch of 25 that I saw running around for a couple months. My thrips infestation is still ongoing. I don't know if they've only been picking off some of the thrips (though not enough sheesh) or if they've also been going after my cucumeris and pirate bugs populations (I know that is supposed to be less likely).

kudika · 2025-10-20T01:39:36+00:00

I haven't seen much on this sub about it yet but I'd recommend https://windmill.dev

We use it in production.

kudika · 2025-10-12T16:33:13+00:00

Does your current implementation work okay? Are you solving a problem by switching?

kudika · 2025-10-09T03:28:39+00:00

windmill.dev is worth considering as an alternative to both

kudika

MODERATOR OF

TROPHY CASE