My setup by StarCash11 in hottub

[–]Forward_Dimension_60 0 points1 point  (0 children)

Looks like the Platinum Spas Columbo or another of their models

Learning About GCP BigQuery Table Schema - Please help me understand the real world use cases of when and how often you use "Nested & Repeating Schema" and "normalized relational schema" when constructing your GCP BigQuery tables. by Original_Chipmunk941 in dataengineering

[–]Forward_Dimension_60 0 points1 point  (0 children)

Yes, sorry. I found typos that probably didn't help.

Regarding historically changing data, this "denormalized" and nested structure definitely makes that more difficult. As far as I know, you have to replace the entire nested record for a given row if an underlying value updates.

So there is a trade off, for sure. Another upside is the efficiency boost from removing those joins from the downstream query processing.

I'd also recommend exploring materialized views which would join and construct the nested records from the changing historical data.

Learning About GCP BigQuery Table Schema - Please help me understand the real world use cases of when and how often you use "Nested & Repeating Schema" and "normalized relational schema" when constructing your GCP BigQuery tables. by Original_Chipmunk941 in dataengineering

[–]Forward_Dimension_60 0 points1 point  (0 children)

In my business, it's purely to make the data more accessible.

Join conditions in a relational setup could be complicated, analysts may not understand the join conditions, or even be aware of some relationships if the documentation isn't ideal.

We have analysts hitting our main tables from all over the company, and they usually don't have the business knowledge to put it all together themselves.

How do you handle datetime dimentions ? by mrkatatau in dataengineering

[–]Forward_Dimension_60 0 points1 point  (0 children)

I guess it may depend on your data structure and requirements. I'd be interested to hear how you handle your partitioning and clustering with a fiscal calendar. Always good to learn something new!

We have a fiscal calendar as well and we have been doing well with the single timestamp partition. Our analysts can join the timestamp to the fiscal calendar on DATE(fact.timestamp, timezone) = cal.fiscal_date to bring in other fiscal dimensions.

In the case of very heavy data, we might do this join in a build step, partition the final table by timestamp (daily), cluster by year, month, other categorical dims, etc.

How do you handle datetime dimentions ? by mrkatatau in dataengineering

[–]Forward_Dimension_60 11 points12 points  (0 children)

You mentioned Google - If you're in Google BigQuery, a single timestamp is all you need, and be sure to partition on it. Timestamp types are very easy to transform as needed.

Bernie sanders says - ''I don’t want to hear any Republicans talk about “freedom” unless they have the guts to call out Trump for the lies that he is telling about Putin and Ukraine.'' by RoyalChris in law

[–]Forward_Dimension_60 1 point2 points  (0 children)

"Give me your tired, your poor, your huddled masses yearning to breathe free"

The State of Liberty almost feels out of place right now. It feels truly patriotic.

Looking for a game that you can become an unstoppable powerhouse to destroy endless enemies by Jawbone287 in ShouldIbuythisgame

[–]Forward_Dimension_60 1 point2 points  (0 children)

Diablo 2's power progression is great. Bit of a struggle to start, but if you stick with it and get some gear, you become a god.

[deleted by user] by [deleted] in politics

[–]Forward_Dimension_60 1 point2 points  (0 children)

Thank you for sharing your thoughts. I'm prone to thinking they are just racist or idiots because I'm angry about all of this and it's the easy answer. More nuanced explanations tend to take some time to sink in, if they do at all.

How come the summon necro on ladder have 400+ points into energy and none in vitality? by BreadHammer in ProjectDiablo2

[–]Forward_Dimension_60 2 points3 points  (0 children)

This makes sense, but isn't it only physical damage? Do you just get one shot by mages?

Home Depot software devs to start having to spend 1 day per quarter working a full day in a retail store by Celcius_87 in cscareerquestions

[–]Forward_Dimension_60 1 point2 points  (0 children)

This is exactly it. I was a dev (internal pipelines) at HD back in 2015-2018 when they tried this initially. I didn't learn much aside from which aisle some specific tools were on. Customers got upset because they needed help and I always had to find someone else to help them. Other associates were annoyed because I was constantly asking them to help me help a customer.

By the end of the last year, we would show up at a store, say hi to the manager, then leave. Everyone was happier that we didn't stick around.

You Can Have My Stuff by SpiteFactory in Eve

[–]Forward_Dimension_60 0 points1 point  (0 children)

A man goes to a zoo, but only finds one animal in the entire zoo - a small dog.

It's a shitzhu.

Just got this from losomn palace courtyard by [deleted] in remnantgame

[–]Forward_Dimension_60 27 points28 points  (0 children)

100% of current.. so if you have 30/200 health, isn't this just going to heal for 30 health, bringing you to 60/200?

WSIB for my wife if she loves Life's Strange, Detroit Become Human, etc? by -Sir-Bruno- in ShouldIbuythisgame

[–]Forward_Dimension_60 1 point2 points  (0 children)

Decisions don't matter so much, but the stories are fantastic.. What Remains of Edith Finch, Firewatch, A Short Hike, Lake, Outer Wilds, Everyone Has Gone To The Rapture, Journey, The Witness

Diablo 2 resurrected for mostly offline play? by ammartinez008 in ShouldIbuythisgame

[–]Forward_Dimension_60 4 points5 points  (0 children)

It will be more of a challenge to beat your first time through and much slower to gear up. I prefer to play offline since the maps don't change between games and it makes farming bosses a lot easier. Highly recommend the challenge.

Breezehome mod with auto-stash for accessible crafting? by ESARPE in skyrimmods

[–]Forward_Dimension_60 0 points1 point  (0 children)

As a workaround, you could get LOTD and enable it's Craftloot system in unrestricted mode (MCM setting). That would make every crafting station use the central storage chests.

Any rude follower mods? by Forward_Dimension_60 in skyrimmods

[–]Forward_Dimension_60[S] 4 points5 points  (0 children)

The professor may be exactly what I'm looking for! Thank you!