Brandon Roberts
thatrobertsguy.com
Brandon Roberts
@thatrobertsguy.com
RDBMS appreciator, data engineer, etc.
I love the Miltons GF frozen pizzas from Costco. Kirkland brand is meh imo
January 5, 2025 at 9:58 PM
I definitely read your post the other way, but yeah, this way is bad too. I hadn’t noticed they don’t have a setting for it.

I will skip liking your upstream reply - solidarity!
January 4, 2025 at 6:07 PM
Dopamine roulette
January 4, 2025 at 5:41 PM
Adjacent
January 4, 2025 at 5:35 PM
we are so back, etc.
December 29, 2024 at 9:22 PM
RT’s voice was never my thing but I felt the exact same way the first time I heard the acoustic version of “Push” - he was not just a guy trying to pump out radio plays.
December 7, 2024 at 9:41 PM
inb4 the e/h2o bros show up
December 1, 2024 at 11:28 PM
Totally understand this feeling 😆
November 29, 2024 at 5:55 PM
Can confirm the recipe is AWESOME
November 28, 2024 at 4:14 PM
I’ve got 4 boys and my standard was “we did, 4 times”

Wish I’d thought to add the vasectomy bit though - Intrusive question, meet over sharing!
November 19, 2024 at 3:14 PM
Off topic but delighted to see aplomb in the wild
November 15, 2024 at 3:39 PM
The business requirement/problem (consolidate multiple instances of a table) and the use of storage layer vs. SQL to do so. I’ve bumped into this twice with similarly implemented ERP systems, but maybe it’s just not that common otherwise? Thanks for engaging on it!
November 15, 2024 at 3:35 PM
I feel like the corollary to this is everyone wants to believe they’re Rick Rubin
November 15, 2024 at 3:26 PM
The ext table presents the same result (plus some metadata) as if you’d unioned all the source tables.
November 13, 2024 at 5:00 PM
I wasn’t very clear in my wording - this is multiple physical source tables (one per business entity). I’m extracting each table to a separate file. All instances of a given table (entity1.customer, entity2.customer, etc) have the same columns, and I’m exposing them all using one DW external table.
November 13, 2024 at 4:56 PM
One or more file per entity, if that matters - N files per table.
November 13, 2024 at 4:20 PM
I land them in a common data lake location and provide access using a view. It’s effectively a union but at the file level instead of SQL.

Is there a name for this?
November 13, 2024 at 4:15 PM
We’re not sure what else is in this one of ours but we’ve loved having Pyrs!
November 12, 2024 at 6:23 AM
Is that a Great Pyr? That expression is very familiar
November 12, 2024 at 3:43 AM
<screams in COTS design decisions>
November 8, 2024 at 3:19 PM
Absolutely not. Poast on.
November 4, 2024 at 1:05 PM
Clearly time for an SR 😄
October 31, 2024 at 6:12 PM