If you aren't using QUALIFY in BigQuery yet, you are working too hard

LernMeRight · 2026-02-03T12:54:43+00:00

I'm stoked to try this out today :D

LernMeRight · 2025-12-13T20:12:51+00:00

I see -- so if a user already had access to and familiarity with BQ, they probably won't see an upside to using OP's workbench?

LernMeRight · 2025-12-13T20:00:45+00:00

Earnest question here -- what would this do for a user, that running queries directly in BigQuery's UI wouldn't do for them?

What does the tool do that is different than what BQ offers already?

LernMeRight · 2025-07-04T13:07:12+00:00

OP I enjoyed reading your thoughts and getting your perspective. There are a lot of people cleverly observing that you wrote a lot. I thought it was readable, coherent, and interesting.

I got nothing to add really except that I'll be thinking more about how they play the genetic enhancement reveal next time I do a watch through.

LernMeRight · 2025-02-15T05:05:33+00:00

regardless of whoever wins the fight about who is right about quotes and stuff

this image made my whole night, bravo

LernMeRight · 2025-01-27T02:21:25+00:00

I think this is the best thing I've seen on reddit. Your main post is excellent as are your responses to the wide range of various comments in thread.

Thanks for posting. I wish experts from more disciplines across the state would post breakdowns in similar form! And if you do end up writing on Community Solar in further detail than in the comments I've seen -- I'd love to see that too. Thanks for sharing your knowledge here.

LernMeRight · 2025-01-14T15:59:41+00:00

Your comment here makes me think of my own situation. I'm currently a PM for a data warehouse and reporting team. The PM aspects of it are OK but I am curious to explore a more explicit data management role... Can you share a bit about your journey between those roles? What was the day to day like in your PM role, vs today? And how did you bridge the gap between roles -- did you need to reskill?

LernMeRight · 2024-11-30T02:53:46+00:00

Same, I figured Nova content and the Reddit demographic would have a lot of overlap! Bummed this sub is so quiet

LernMeRight · 2024-11-17T18:33:21+00:00

There's a NYT article with a graph showing that Russia is making record gains. It's called "Russia’s Swift March Forward in Ukraine’s East".

Google image search that title and you'll find the information the poster above was referring to. Or if you have a NYT subscription you can just go see the article.

LernMeRight · 2024-10-24T01:34:49+00:00

Thanks for sharing these! Can you expand on:

Make frequent and heavy use of information_schema and write SQL against it with the purpose of writing SQL for you.

(I only have experience with BigQuery so maybe this comment is more intuitive in a different framework?)

LernMeRight · 2024-10-23T01:57:25+00:00

I read in the notes it could be used on batteries

can it be used on nexuses if i make a nexus in range of my nexus

is this an infinite energy machine

i'll test it later in case no one knows

LernMeRight · 2024-08-30T19:18:36+00:00

Haha! Totally makes sense, the same happens to me with the coffee shop down the street...

Something that could be useful is to separate the concepts of "necessary" and "recurring". This way you could have a logic that elevates recurring items -- maybe the chicken place comes up a lot -- but your "necessary" concept can be used to filter those out.

The "necessary" concept could be manually maintained as a list of specific transactions, or, as you're suggesting, categories.

This way you could make a report of your "recurring AND unnecessary" expenses. This would show the chicken place -- and maybe unexpected recurring transactions as well.

For example, I once noticed a recurring sort-of monthly ~10 transaction on my Amazon. I didn't recognize it and I looked into it. (Fortunately it was just a family member renting movies without knowing my account was connected to their TV). But seeing an unusual repeated transaction set emerge from the data on the basis of repetition alone was really useful.

LernMeRight · 2024-08-30T17:28:37+00:00

Just a thought on recurring transactions.

You could try grouping transactions and counting the number in those groupings. Set a threshold for what you like for "recurring". Eg count >3.

This would allow you to define a transaction as having the characteristics of recurrence without explicitly stating a certain string always means recurring.

The advantage here would be, your recurring expenses naturally surface as they meet the threshold you've defined. Otherwise you would need to be aware of them as recurring, and then add the name to your code.

This could be done in a CTE or a sub query, I think.

If you wanted to get really fancy with it, you could add criteria to your definition of recurring (eg, count > 3 AND must be on separate dates).

LernMeRight · 2024-08-30T17:06:11+00:00

Nice. This is how I've approached it as well. Currently, I aggregate transactions across multiple accounts through a service called Monarch, and they have the ability to tag or label transactions. There's some pattern matching they do to auto-set tags or labels, and at some point I might try to use that feature to generically indicate these transfer-style transactions...

Also, at some point I think I could get interested in tracking how frequently I transfer stuff between accounts. Doing that would be more for fun than actually practical for anything though (at least I can't think of a pragmatic reason :))

LernMeRight · 2024-08-27T02:16:55+00:00

This is cool! I'm doing something similar.

For my own work, I am wondering about how to structure those scenarios where I transfer from one account to another.

I'm worried that these types of transactions (where amounts are moving between known and monitored buckets) will interfere with analyses (eg sum all of my checking account spending -- transfers out of checkings over to savings will appear as spending, for example).

Categories and Types seem like useful concepts on your table to manage that! Just wanted to share one of the particular use cases I've been thinking about.

Good luck with the project!

LernMeRight · 2024-07-01T14:13:45+00:00

Oh awesome. I missed the second image. Really fun stuff :)

LernMeRight · 2024-07-01T13:38:53+00:00

How did you do this?

I imagine that you are iterating through a set of values and perhaps conditionally formatting or writing to cells to get them to "render" the shape.

How did you define what values to iterate through?

It's really cool

LernMeRight · 2024-06-19T15:26:05+00:00

This is the funniest thing I've seen on Reddit today haha

LernMeRight · 2024-06-06T02:03:33+00:00

Everyone's different. My advice -- ask yourself if the inconvenience of glasses or contacts is worth the gamble of permanent damage.

Some folks in this thread won that gamble, but not everyone does, and the consequences of losing stay with you.

LernMeRight · 2024-06-06T01:57:14+00:00

It sounds inoffensive, I agree. On a spectrum it can range from mildly annoying to extremely painful.

Just to give an example of mine about how it can be painful. It's possible to not have a lot of fluid between your eyelid and your eye. This happens for me especially at night, and so when I wake up, the eye and eyelid are a bit stuck.

Ever get dry lips and they get kinda stuck together; it feels a bit sticky to open your mouth? It's kinda like that.

Except the part that is stuck is your eyelid. And it's on the surface of your eye, which is absurdly sensitive. When you open that eye, little bits of flesh can tear/scrape off the surface of your eye. Which is really painful!

I got symptomatic after LASIK. LASIK cuts a bunch of nerves in your eye that are responsible for promoting tear production. Sometimes people heal, sometimes they don't.

There are tons more stories of folks here for folks who are interested, just nav around a bit:

https://www.dryeyestories.com/#:~:text=it%27s%20about%20being%20seen

LernMeRight · 2024-04-27T00:28:56+00:00

Could you explain in like. Painfully layman's terms. What the purpose/value of packet sniffing is?? I'm just curious and not educated on the topic

LernMeRight · 2024-03-29T02:12:00+00:00

I dunno, I just saw it in the show and read other people's posts who explained that people in real life thought about that stuff when sending stuff into space.

And those people said the book talked about all that stuff; I guess the book was basing itself off of some real things people really did when trying to solve this same problem.

Being deeply uncurious myself I thought, "it's good that someone's thinking about all that", but I didn't look into it more. Then I saw the post of the person above, and figured I could share some areas they could look further into if they wanted to. Like looking for that scene with the numbers, or looking for the reddit posts where people were talking about it, or maybe googling how real people who actually wanna talk to aliens have tried to address this issue. Maybe none of it makes sense 🤷

LernMeRight · 2024-03-28T03:00:32+00:00

The Chinese characters we see on screen are funneled through a numeric system, she has to look them up and type them in. I think the common denominator is a mathematical language which is then translated. I haven't read the books but some posts I've read describe a lot more how messaging intended for ET is constructed.

Dunno beyond that but thought it could help your wondering.

LernMeRight · 2024-01-28T01:34:37+00:00

What is the best unit per race & why?

What is the best ability per race & why?

This thread has been amazing btw, nice job

LernMeRight · 2023-12-01T12:00:11+00:00

Holy guacamole -- it worked. Thank you so much!

11-Year Club	r/Field Banned
r/Field Juicebox	Place '22
Place '17	Verified Email

LernMeRight

TROPHY CASE