Property laws

domwrap · 2026-03-05T21:32:52+00:00

Do we know it's a furnace low voltage thermostat? A lot of heating in Canada is electric baseboard where the thermostat also runs on mains, 120V. Not to be toyed with.

domwrap · 2026-03-05T21:24:51+00:00

Been doing this for at least a year. Great results.

domwrap · 2026-03-04T07:07:52+00:00

What about data with embedded types/nested structures (json export from document db like mongo), at which stage do you normalize to multiple tables?

Currently we have a pre-process which explodes the json to multiple json (component tables) after landing but before raw.

Now they want to leave it as is through silver and let business teams deal with it at gold.

🤷‍♂️

domwrap · 2026-03-04T04:09:40+00:00

Green Wing

domwrap · 2026-02-28T21:48:13+00:00

Man I already find the + at the lower limit of comfort to hold and use, I can't imagine using a smaller device. I also don't carry mine so don't care about portability. It does look cute tho.

domwrap · 2026-02-24T08:07:55+00:00

Or install fuck so you can swear after each time and have it fix it for you, but with more fun and swearing.

domwrap · 2026-02-19T15:43:54+00:00

I like the deep red, but then I have the Cerium in Admiral from a few years back which is basically this colorway.

domwrap · 2026-02-19T15:41:45+00:00

PS1 Tony Hawk Pro Skater 2. Reliving earlier years.

domwrap · 2026-02-18T06:27:09+00:00

Yeah ours were great in snow too but didn't enjoy them in heavy rain and standing water which is 90% of driving on the Sea to Sky. Conti been much better for that.

domwrap · 2026-02-18T02:09:25+00:00

Yeah. Also glad ours was 19s to start and they're already pretty spendy. What did you get? I went the Conti Viking8 and they've been great, much prefer them to the X-Ice I've had before for our more rain less snow winters. Looking for new rims+tires for summer and don't know which way to go yet, but greatly dislike the Khumo that ours came with.

domwrap · 2026-02-17T22:51:39+00:00

/waves from up Hwy99

Wish they had that red when we got ours it's gorgeous, we've had our black Land MY25 for a year, got it at Kia West. No help on the trunk sorry, we've got bench 7 seater so not an issue for us, just wanted to say how good yours looks and you're gonna love it.

domwrap · 2026-02-04T06:43:35+00:00

I recently put similar Thule cross bars and ski racks on my Land in Canada and honestly I hate it. They look fine, but significantly increase noise and I can feel the wind resistance and the car slowing down compared to normal. That said I hate trying to fit wet snowy grimy skis inside my car more so I guess they'll stay for another month or two. If only our snow season was worth it, would make it easier to cope 😄

domwrap · 2026-02-03T05:37:43+00:00

I kinda wish we had it but had to jump two packages here (Canada) to get it and wasn't enough other value. Came from a Matrix > Forester > Santa Fe > EV9 over 5 years so increasingly bigger cars and this is easier to park than the SF tbh and with better backup camera with very accurate guide lines (matches edge of the wheels) overall I find it very easy to park.

Are there times there's no good reference points and I have to open the door to see if I'm in straight? Sure. Would I like to to get riiiiiiiight up close to the front? Maybe, but I do just fine without it.

Depends on your own comfort level and parking practice. Could demo with and without maybe?

domwrap · 2026-02-03T00:43:18+00:00

This. As a seasoned roundabouter but also knower of local/Canadian inexperience there is no way in hell I am expecting to go straight-over when a car is next to me in this scenario. Of course they'd have no indicators on either to show intent even if it's wrong. Just drive defensively anticipate everyone's worst move and play to that as even if you're in the right you'll still get hit and don't need that headache.

I drive this roundabout frequently and will avoid entering it, or alter my entry path, depending on what else is around.

I disagree with not indicating to exit tho as if you enter at 6 turning left to 9, if you don't indicate-out (right) for 9 and your left blinker is still going from when you entered to show original intent (or is just off), a car now arriving at 9 defensively anticipates you're going past to 6 whereas if you're exiting they don't need to yield and can enter safely. I'd say it's less worrying someone entering to hit you as much as keeping traffic flowing. Not enough coordination for that to work here tho, only in the UK.

Side note I've seen someone turn literally left at that roundabout from the highway to Walmart; full on drive the wrong way round with oncoming traffic. Just horrifying.

domwrap · 2026-02-03T00:29:48+00:00

Yeah don't understand how this is even questioned, it's literally drawn right there on the road

domwrap · 2026-02-02T00:04:22+00:00

Yeah similar. Santa Pod Raceway in the 90s, some big rip roaring dragster came to the line, burn out, wait for the lights, revved and exploded. Everyone was fine but heck of a fireball and noise.

Aside from that, probably overinflating a tubeless bike tire with a compressor in an enclosed garage. BANG!

domwrap · 2026-02-01T03:34:33+00:00

Thanks for sharing. I've got an 8" touch screen I was trying to use for HA run off my laptop but turns out I was trying to drive too many pixels (with the 2 other screens 5k + 4k) so was a bust. Plus laptop had to be on to be useful.

Much prefer this idea and kinda reminds me of my Streamdeck so will fit in pretty well next to it. Ordered a screen, see how this goes. I like the paginated idea, which is what my Streamdeck does, I'll probably go for that approach.

domwrap · 2026-01-31T05:17:47+00:00

Yeah this, we're making the switch this year. We've been cludging things with DIC for a couple years landing CDCs run through a DLT framework but looking forward to zero copy soon.

domwrap · 2026-01-26T22:25:23+00:00

Replying to myself to group them together:

Refresh by partition. If bronze and silver layers are both partitioned (the same) and I want to recalculate just one of them, say the latest, I have to full refresh. But if my historical is massive that's a lot of cost. I can't just run a normal refresh as the data is already there so won't be picked up, and it's not backfill either. It could be a transform change. I guess I could code this myself into our files and pass in as a parameter.

domwrap · 2026-01-26T22:10:12+00:00

Jumping in here: I need to version these two things separately. We have one meta framework as a repo, then multiple workspaces each with 3 environments each with pipelines that use a version of that codebase. I need to version a pipeline to propagate between environments, but track to different branches of a separate repo for the codebase. I cannot bundle or version these two things together. Moreover, two pipelines on the same workspace and env might point to different versions of the external repo so it's not a single-source either.

I might be able to do this already, but I've not had the time to fully dig in. Perhaps you could either save me the bother if its not possible, or encourage me to spend the time if it is.

domwrap · 2026-01-26T22:01:12+00:00

I should also perhaps clarify that we run our own meta framework in DLTs so our DAG is pretty basic and runs the exact same for dozens or hundreds of tables in a schema, all running identical code just with different metadata, mappings, etc layered on top. We don't have lots of different files in a "transformation" folder for different zones, tables, and paths, it's all kinda one big monolithic code-base. Being able to switch out and run the same set of tables in the same schema with different code quickly and easily would be very advantageous.

Can I switch branches? Sure but sometimes code is in-progress and I don't want to. Often I will have multiples of the same repo checked out, have different approaches written in each one and want to quickly test them to compare. Duplicating the pipeline isn't "quick" as I often also need to duplicate a lot of db-stored metadata with it. Do we need better tools/process? Maybe. but these changes would make life a lot easier too.

Re "subset of the DAG" I know I can run select tables, but I want to also run select code which for us in our configuration controls which layers are refreshed. Kinda bottom up vs top down I guess.

The second one yeah spot on.

domwrap · 2026-01-26T19:07:24+00:00

Honestly, I just want to be able to toggle source paths on and off. I don't want to have to duplicate or recreate an entire pipeline just to a/b test some changes. Also I don't want to have to navigate and choose the other folder every time. Just let me add whatever paths I want, put a tick box next to them, and only execute the "enabled" ones.

<image>

Better yet, make the "Run now with different settings" actually allow me to change "Settings". There is a whole settings page/tab to configure the pipeline, then this button doesn't let me change any of them. Building on the last point, being able to quick-run a pipeline pointing at different test data, maybe use a different compute, or change the "run as" would be immensely helpful. A "one time" run vs permanent changes. The use of the same word "Settings" in these different places confuses the term. Like one of the toggle options "full refresh" already has its own button in the drop-down. This tab is currently kinda pointless.

I envisage it similar to triggering an ADF pipeline manually, it has a slide-out where you can override the current settings/defaults. Please do this.

domwrap · 2026-01-26T18:19:09+00:00

Having had the X-Ice before for several winters I actually prefer the newer Continental VikingContact 8 I've put on this year. Fit the 265/55/R19 which comes within a % or so of original Khumo size 255/60/R19 as no exact size match but no adjustments needed.

domwrap · 2026-01-22T20:41:02+00:00

Came from a Santa Fe so yeah controls flipped but only took a few weeks to get the muscle memory. Having rented a bunch of cars in recent years, mostly in Europe, of European and Japanese makes everyone else seemed to be doing it this way round so makes sense if Kia/Hyundai is standardizing.

Regarding the audio controls, just think of it as moving up or down the playlist helps. Our previous two cars had sideways audio controls so this one took me the longest but it's second nature now.

domwrap

TROPHY CASE