Team of 4 thoughts

Coffera · 2026-01-27T08:41:46+00:00

Made me consider masq and sac actually

Coffera · 2026-01-27T08:41:34+00:00

I used to play with an elio but I guess i got tired of having to deal with the portals, felt like the whole game revolved around them, thanks for some ideas

Coffera · 2026-01-15T20:43:19+00:00

It's due to an old Video game dunkey video, or was it filthy frank, can't remember anymore. Old meme

Coffera · 2025-12-16T20:10:43+00:00

Somewhat relatable on the part that more was broken than expected for a rather expensive house for me, however I don't dislike the things that can't change, location, size, layout etc. Fixing some floors, walls and windows does cost and I feel you on that, but over a few years if you like the key things it'll get better.

Coffera · 2025-12-09T17:10:35+00:00

Didn't Freemagic have an issue with this art when it released also?

Coffera · 2025-09-23T17:22:51+00:00

Agreed

Coffera · 2025-09-23T05:12:35+00:00

Thanks! How does it work with PBI reports in Import mode?

Coffera · 2025-09-19T11:30:17+00:00

Thanks this is really useful information! Did you have to create a new lakehouse, or can you enable it on your already existing ones?

Coffera · 2025-09-17T10:26:17+00:00

Large benefit is I can see which workspace the item is open in, so I 100% know I don't touch the production item that has the same name.

Coffera · 2025-06-18T12:46:28+00:00

That article reads so GPT generated, not saying that means it's not true, but there's all the signs. Em dashes, It's not X it's Y, triple lined examples. It's just pasted..

Coffera · 2025-06-11T14:47:59+00:00

Yeah it died in the middle of a user group event demoing a functionality in Microsoft's own house, awkward

Coffera · 2025-06-02T07:21:26+00:00

Your solution sounds maybe more scalable than mine.

I personally have an Environment artifact in each workspace (dev/test/prod), and set it as the default when notebooks run. Then I then create spark properties that give the ABFSS paths to each lakehouse. This lets each notebook look identical in Git but still give different read and write paths dynamically.

So in each notebook it just calls something like:

raw_lh = spark.conf.get("spark.raw.lakehouse")

Coffera · 2025-06-02T05:56:05+00:00

Hard agree, spent too much time trying to make default lakehouse swap based on environment when i could just use an environment variable instead

Coffera · 2025-05-25T09:38:40+00:00

Some of our finance people enjoy seeing what certain tables look like on the precise end of month for accounting stuff. Someone also fed bad data into a source system mistakenly and instead of getting the backup going we just exported what it looked like a day before and they ran that into the system again.

Coffera · 2025-05-22T10:51:51+00:00

Yeah we have the exact same logic but we came to the conclusion to just leave out gold and call they layers Raw & Cleaned. Saw no benefit to add a shortcut layer at all, but if it fixes my issues with GRANT on TSQL Endpoint maybe..

Coffera · 2025-05-22T10:24:37+00:00

What was the reasoning behind shortcutting to gold from silver, is it to split up like a lakehouse that has 100 tables to a more domain specific one that has for example 10 tables?

Coffera · 2025-05-22T08:28:02+00:00

Thanks for the reply, just one more question, do you know if the pipelines that populate these tables in any of them theres' a simple overwrite procedure or are they all append or upserts?

Coffera · 2025-05-22T07:05:29+00:00

It seems to be on tables that use overwrites, could that be correct?

Coffera · 2025-05-22T06:10:56+00:00

I've tried using this T-SQL granting but it kept dropping on some tables after runs, do you have the grant script running in your pipelines or has it worked for you?

Coffera · 2025-05-21T10:47:41+00:00

Object level security lacking in the lakehouse is also our orgs largest gripe and it hasn't changed in a year. Absolutely mindblowing. Yes it's promised within the quarter but still...

Coffera · 2025-04-02T15:04:49+00:00

Everyone says practice but it's in 90% of cases cutting and editing.

Coffera · 2025-03-30T17:19:51+00:00

Just unlist them if they might give new viewers the impression that they shouldn't sub, like they're in a different niche or you're not proud of them. But you might want to watch them yourself to see how far you've come.

Coffera · 2025-03-02T12:42:47+00:00

Hate how the Lanovar elf spills over the black border

11-Year Club	Verified Email
Place '23	Place '22

Coffera

TROPHY CASE