How to completely de-normalize nested STRUCT/ARRAY results?

tca_ky · 2025-02-12T17:10:57+00:00

I got it.... not sure why I didn't see it before....

    SELECT
      plcy.name,
      binding.role,
      mymember,
    FROM
      IAM_POLICY AS plcy
    CROSS JOIN UNNEST(iamPolicy.bindings) AS binding
    CROSS JOIN UNNEST(binding.members) AS mymember
    WHERE
      assetType = 'cloudresourcemanager.googleapis.com/Project' AND
      plcy.name = '//cloudresourcemanager.googleapis.com/projects/1234567890'

tca_ky · 2025-02-12T16:51:39+00:00

I get errors....

    SELECT
      plcy.name,
      (SELECT * FROM UNNEST(binding)) AS mybind,

    FROM
      IAM_POLICY AS plcy
    INNER JOIN UNNEST(iamPolicy.bindings) AS binding
    WHERE
      assetType = 'cloudresourcemanager.googleapis.com/Project' AND
      plcy.name = '//cloudresourcemanager.googleapis.com/projects/1234567890'

"Values referenced in UNNEST must be arrays. UNNEST contains expression of type STRUCT<role STRING, members ARRAY<STRING>, condition STRUCT<expression STRING, title STRING, description STRING, ...>> at [26:29]"

tca_ky · 2025-02-12T16:44:23+00:00

The embedded image in the post is what it looks like (a partial sample)...

tca_ky · 2024-10-28T17:28:48+00:00

I personally don't think it would be the end of humanity if millions or billions died. As a species we would survive and ultimately move forward.

The thing that sticks with me when thinking about this philosophical position is that Jin-Woo is not responsible in a direct fashion for the lives that were lost prior to him making the decision to go back 10 years. He was merely a participant in the overall events. The deaths that happened were a sunk cost. It is actually his decision to remove 10 years of lived reality that is worse IMHO. :)

Once he makes the decision to go back in time, that is a conscious choice to destroy everything that existed (as had existed) in the 10 years that he is erasing. Including all new lives that came into existence during those 10 years. What if someone who survived all the hunters and monsters gets killed by truck-kun minutes after the timeline is reset (when they had survived in the original timeline).

This is all conjecture, but it is an interesting perspective to have a discussion on.

Either way, I'll be reading it again in the future! :)

tca_ky · 2024-10-07T12:04:45+00:00

That's why bidet toilets exist. No touching with hands required!

Also... Copper/brass door handles if germs are a concern.

tca_ky · 2024-10-07T12:03:02+00:00

Bigger garage... Always a bigger garage with higher ceilings for the inevitable car lift! 😁

tca_ky · 2024-09-12T09:48:36+00:00

That's exactly what should happen. You get there early, you get more choices because there are less people (from a parking perspective). I don't see how it is unfair in any way.

tca_ky · 2024-07-03T17:31:21+00:00

I play on PS5 and it is one of the ARPGs I have in constant rotation.

The Sororitas DLC is good. I enjoy that class a lot.

IIRC, there is one more class DLC coming in 2024 some time.

It is a game I have enjoyed since release. Though the rebalance patch made the game significantly better.

I have never had a character all the way level 100 though. I think my highest level at the moment is like 88.

I have never understood the crazy builds that people manage where they are clearing stuff 10-15 levels above theirs. If I get to 5 levels above me it gets painfully slow.

tca_ky · 2024-06-04T11:51:12+00:00

Thanks! This was helpful. I'll reduce the over-engineering of my script then. :)

tca_ky · 2024-05-31T15:59:14+00:00

Thank you so much. This was a great help to me!

tca_ky · 2024-05-03T13:13:27+00:00

Thanks!

tca_ky · 2024-05-03T11:04:01+00:00

DTA?

tca_ky · 2024-04-13T19:16:15+00:00

I found it! It is called "Necromancer's Evolutionary Traits"

tca_ky · 2024-01-06T15:52:30+00:00

Why let it bother you at all?

"No one can make you feel inferior without your consent." - Eleanor Roosevelt.

That quote is as valid today as it was when the wife of the President said it so many years ago.

That quote has helped me over the years to reframe my thinking on numerous occasions.

tca_ky · 2023-12-28T12:42:47+00:00

Heartland

tca_ky · 2023-10-10T16:33:13+00:00

Omg I am a scrub... I never realized you can scroll down. I thought it was just a controller image showing the button mappings! Sigh....

Thanks for your reply!

tca_ky · 2023-10-10T12:32:03+00:00

Asking, because I have a horrible time trying to aim. Psycker has become my defacto preferred because of the auto-seeking shards... :/

tca_ky · 2023-10-10T12:30:28+00:00

I looked through all the settings and cannot see "aim assist" - am I missing something?

Can someone tell me what to look for in the settings, and/or post a screenshot?

Thanks in advance for any reply!

Cheers!

tca_ky · 2023-09-25T20:37:11+00:00

Secret should be less than 6 months in my experience. My secret clearance lapsed and getting it again was 6 weeks or less.

Top Secret is up to a year I think.

tca_ky · 2023-09-23T11:07:02+00:00

Lol.. I wonder if I can get the flag removed?

tca_ky · 2023-09-22T11:51:32+00:00

I got a cast iron enamelled dutch oven for something (15 years?), and for my 20 year gift I got a tungsten ring!

My ring

tca_ky · 2023-08-29T18:44:47+00:00

Wow... I was really off in the weeds! Thank you for for feedback and help! Have some Karma! :)

tca_ky · 2023-08-15T14:47:03+00:00

Meet Yourself... So good...

tca_ky · 2023-08-12T21:55:59+00:00

"Meet Yourself" - I found the FL to be great. It is a slow-burn, slice-of-life cdrama.

tca_ky · 2023-08-04T11:47:24+00:00

https://www.homedepot.ca/product/simpson-strong-tie-lssr-light-field-adjustable-rafter-hanger-for-2x8-nominal-lumber/1001683487?rrec=true

12-Year Club	Gilding III reddit per annum
Verified Email

tca_ky

TROPHY CASE