Real Randy's Avatar

Real Randy

@emotional-schema

It’s really me

34
Followers
44
Following
54
Posts
30.10.2024
Joined
Posts Following

Latest posts by Real Randy @emotional-schema

They just need to sell it already in a whiskey flask for treatment on the go

17.01.2025 12:38 👍 1 🔁 0 💬 0 📌 0

There are two kinds of people in the world:
1. Those that measure out their Robitussin the right way
2. People like me

16.01.2025 12:32 👍 2 🔁 0 💬 1 📌 0

Tableau was so so good. I loved the dev interface so much.

I learned tableau way before learning SQL and I’m really glad I did. It was much easier that way.

The closest thing I’ve found to that is the experience from Sigma computing, but they don’t offer a single user tier.

#databs

24.12.2024 21:45 👍 1 🔁 0 💬 2 📌 0

This guy’s living in 9999

17.12.2024 13:14 👍 1 🔁 0 💬 0 📌 0

THE BEST

17.12.2024 10:35 👍 1 🔁 0 💬 0 📌 0
Post image

Raycast is my favorite tool of all time. You gave me my original invite 🙏

I think they’ve got the best wrapped around. I lost half my history this year moving to a databricks laptop but still so fun to see.

Spotify was my top app for sure haha.

17.12.2024 10:30 👍 1 🔁 0 💬 0 📌 0

Nothing like a "Weekly Huddle (Mandatory)" to set the right tone on a Monday 👌

This is not my team, thank goodness hahaha.

16.12.2024 16:16 👍 0 🔁 0 💬 0 📌 0

What?? Snowflake iceberg is parquet in s3

13.12.2024 15:18 👍 1 🔁 0 💬 0 📌 0

What are the two sides

13.12.2024 01:49 👍 1 🔁 0 💬 1 📌 0

I knew I had to be missing something. Thank you, Danny.

Even the example records weren’t making sense the way I read the problem

12.12.2024 13:22 👍 1 🔁 0 💬 0 📌 0

I bet the min isn’t needed as well. The days difference will be null for it and that can be turned into a true in the case statement assuming no null dates in the input.

12.12.2024 02:34 👍 1 🔁 0 💬 0 📌 0

Then you do a case statement:
- If date is the min date, true
- if days diff is greater than 90 (or any arbitrary cooldown), also true
- otherwise false

12.12.2024 02:31 👍 0 🔁 0 💬 0 📌 0

What if you add a window function computing the days of diff between the current and previous entry sorted by date.

Also grab the min date while you’re at it. This is more useful if you need to run this for multiple partitions instead of for just the entire table.

Then…

12.12.2024 02:29 👍 1 🔁 0 💬 3 📌 0

I’ve been thinking about this.

I think an annoying computer science approach can do this without recursion.

I think it’ll run nlogn as well.

I need some paper

12.12.2024 02:26 👍 1 🔁 0 💬 1 📌 0

This comes back to the core missing piece in duck imo. No catalog support.

12.12.2024 00:44 👍 0 🔁 0 💬 1 📌 0

That’s the beauty of it! The answer is always sql hahaha

11.12.2024 00:34 👍 1 🔁 0 💬 0 📌 0

I think you can run duckdb in python. I’ve installed it for a demo but I’m not sure if that is what you mean.

11.12.2024 00:34 👍 0 🔁 0 💬 1 📌 0

Trash. Offensive

11.12.2024 00:09 👍 1 🔁 0 💬 0 📌 0

SQL

09.12.2024 14:05 👍 2 🔁 0 💬 1 📌 0

Bigquery and databricks sql both have it on lock too 💪

09.12.2024 14:04 👍 2 🔁 0 💬 0 📌 0

Wake me up when @duckdb.org supports iceberg catalogs.

Big SQL doesn’t want us to have this.

#databs

09.12.2024 14:00 👍 5 🔁 0 💬 2 📌 0

Start:
I don’t know how we can make this valuable without a semantic layer

Fixed:
I don’t know how we can make this valuable with a semantic layer

Fixed more:
I don’t know how we can make this valuable

Final fix:
I don’t know

#databs it’s all pointless. Just disable sso and lose your login

09.12.2024 13:59 👍 1 🔁 0 💬 0 📌 0

Let’s smoke about it. King sized

29.11.2024 14:45 👍 1 🔁 0 💬 1 📌 0

1 - Poetry just because it works. I don’t package and distribute Python libraries so I have pretty basic package management needs. No opinion on uv either way.

2 - Nothing fancy like that, I just wanted a minimal prompt. It was just trickier than I expected haha

28.11.2024 04:50 👍 1 🔁 0 💬 0 📌 0

I’m a poetry guy, but this would work so nicely there too. Thank you for sharing.

My zshrc is filled with my nonsense language of aliases and a surprisingly long chunk to make my terminal prompt just be a battery emoji 🔋

28.11.2024 01:36 👍 1 🔁 0 💬 1 📌 0

Gotta be at least 100 bucks a month

28.11.2024 01:31 👍 0 🔁 0 💬 0 📌 0

They just don’t get it

28.11.2024 01:06 👍 1 🔁 0 💬 0 📌 0

It fits!!!!!! This rules. 10/10

27.11.2024 17:22 👍 0 🔁 0 💬 0 📌 0
Preview
a man wearing an orange football jersey is smiling . ALT: a man wearing an orange football jersey is smiling .
27.11.2024 13:14 👍 0 🔁 0 💬 0 📌 0
Preview
a man in a blue shirt and tie is opening a door in a waiting room ALT: a man in a blue shirt and tie is opening a door in a waiting room

1. The analysts know sql
2. The data model is in sql
3. The tools support sql
4. Let’s put our cubes in yml ✅
5. Lets serve them over graphql ✅

That’ll be 50k a year, please.

27.11.2024 13:11 👍 1 🔁 0 💬 0 📌 0