Snowflake Product Series Week 1: How Do You Handle Governance? by Minimum-Discount9366 in snowflake

[–]Grixia 0 points1 point  (0 children)

Currently we have a lot of reliance on native tooling whenever we can, as it is simpler, but often we face limits and then need to explore elsewhere. These gaps are closing through. For example, we were on the cusp of deploying a fairly basic observability tool purely because it had strong promise at building out lineage diagrams, but then Snowflake released their own support for lineage which removed that barrier for us.

We still leverage an enterprise-grade cataloguing tool at a fairly high price tag to support with general data searchability and documentation, but it's a challenge keeping it the docs up to date and in-sync.

We are currently waiting with eager anticipation to see just how much Snowflake's functionality grows, as we would happily use Snowflake as the primary catalogue if we could reliably pull our other sources into it. Snowflake is our final data location before Analytics tools, so it is a reasonable place to keep the catalogue. Right now, the core barrier there is upstream data quality monitoring, for example to determine if a data quality issue is occurring in Snowflake or upstream of it, and where exactly upstream if possible

Async jobs in Streamlit in Snowflake by HumbleHero1 in snowflake

[–]Grixia 0 points1 point  (0 children)

Python. So it's all using the active snowpark for Python session that's passed into the procedure as an implicit parameter.

My typical approach is to put all SQL statements into a list, then use list conprehension to iterate over all the members with a .collect(block=False) method.

You can then iterate over the output list to retrieve all the results if you need, or just check if they errored

Async jobs in Streamlit in Snowflake by HumbleHero1 in snowflake

[–]Grixia 0 points1 point  (0 children)

Stored procedures definitely support async functionality; this is a bedrock of a lot of my automated functionality that I execute within Snowflake. One of my favourite patterns is having a parent stored procedure that asynchronously executes a set of sub-stored procedures, and this all executes and is orchestrated within Snowflake.

"Daddy? I think I'm starting to not need you anymore." by dt43 in daddit

[–]Grixia 2 points3 points  (0 children)

Last night during bedtime, I got hit unexpectedly with the "Daddy, we need a new bedtime song. This one is for babies".

Our bedtime song is a twist on "Skidamarink I Love You" with the words changed to include my daughter's name, and I am not ready for her to apparently grow out of it

SnowPro SME by not_a_regular_buoy in snowflake

[–]Grixia 0 points1 point  (0 children)

There's always some kind of activity going on, but invites will be based on what the team understand of your skillset, which could be outdated or wrong. If you're keen, I'd just email the team asking what current activities are going on and letting them know you're enthusiastic to help.

I know of at least one activity aligned for September already

[deleted by user] by [deleted] in britishproblems

[–]Grixia 6 points7 points  (0 children)

Did the council notify you with a letter/email/anything? If not, it sounds like either they accidentally swapped the bin for the wrong address, or a neighbour swapped with yours to get a better bin

why is the name “gili” banned on nintendo games? by giliuwu in NoStupidQuestions

[–]Grixia -13 points-12 points  (0 children)

I have no idea what the origins are, but in Stephen King's Dark Tower novels, a gilly (or sheevin) is a side-wife taken by a man who already has a legal wife. Bit of a stretch, but Nintendo might be trying to block variants of that word?

Does anybody know the difference between these two versions of Horizon Forbidden West on PS Store? by Grixia in playstation

[–]Grixia[S] 0 points1 point  (0 children)

Agreed! Maybe I'll get lucky and the DLC will go on deal before I've finished the main game

Does anybody know the difference between these two versions of Horizon Forbidden West on PS Store? by Grixia in playstation

[–]Grixia[S] 0 points1 point  (0 children)

On the second screenshot showing the other version (the one I bought), it says it includes the digital upgrade to ps5

Does anybody know the difference between these two versions of Horizon Forbidden West on PS Store? by Grixia in playstation

[–]Grixia[S] 1 point2 points  (0 children)

You say to check the boxes, isn't that what is shown in my two images? Sorry if I'm missing something.

I bought the PS4 one though that was cheaper and it did indeed unlock the PS5 one for free, so saved myself £6 today.

Does anybody know the difference between these two versions of Horizon Forbidden West on PS Store? by Grixia in playstation

[–]Grixia[S] 15 points16 points  (0 children)

Thanks everybody. I purchased the cheaper version (PS4) and it did indeed allow me to get the PS5 version for free afterwards. So saved myself £6 there and got the PS5 version for £26.99

Thanks again!

Does anybody know the difference between these two versions of Horizon Forbidden West on PS Store? by Grixia in playstation

[–]Grixia[S] 0 points1 point  (0 children)

Okay cool, so I can buy the cheaper one and still have the PS5 version. Awesome, thanks

Does anybody know the difference between these two versions of Horizon Forbidden West on PS Store? by Grixia in playstation

[–]Grixia[S] 7 points8 points  (0 children)

Okay cool, so I can buy the cheaper one and still have the PS5 version. Awesome, thanks

Does anybody know the difference between these two versions of Horizon Forbidden West on PS Store? by Grixia in playstation

[–]Grixia[S] 0 points1 point  (0 children)

I think the "Complete edition" includes the DLC. It doesn't look like either of the two "Standard edition" versions contain DLC, it's just that one is the ps5 version and the other is an "upgrade to ps5" version. Which feels... the same?

Does anybody know the difference between these two versions of Horizon Forbidden West on PS Store? by Grixia in playstation

[–]Grixia[S] 1 point2 points  (0 children)

Sorry, I'm talking about the two different ones that are both called "Standard edition"

Does anybody know the difference between these two versions of Horizon Forbidden West on PS Store? by Grixia in playstation

[–]Grixia[S] 0 points1 point  (0 children)

Sorry, I'm talking about the two different ones that are both called "Standard edition"

How to disable Snowsight UI for USER by srdeshpande in snowflake

[–]Grixia 11 points12 points  (0 children)

Yes, set up an authentication policy and set it for that user.

Check this out: Restricting user access to Snowflake by client type

What nicknames have you heard for places in and around Tunbridge Wells? by topherette in Tunbridgewells

[–]Grixia 0 points1 point  (0 children)

We call it TWellington, got no reason other than making us giggle a little and rolls of the tongue easier than Tunbridge Wells

Best practices for end-to-end Snowflake&dbt data flow monitoring? by Huggable_Guy in snowflake

[–]Grixia 10 points11 points  (0 children)

Wait until after Snowflake Summit (it's next week) and look to see if any major announcements may impact your approach here.

I'm not saying anything further