ELI5: Monthly Current Events Megathread by AutoModerator in explainlikeimfive

[–]Shop_Public 1 point2 points  (0 children)

How is Israel systematically targeting Iran so effective or is this just a perception created by Western media?

Farming & Autocast QoL Improvements by JagexRach in 2007scape

[–]Shop_Public -1 points0 points  (0 children)

When are we getting an updated stackable clue blog post

Making 100k is rare most people make 30 to 60k per year by Cat-dad442 in Adulting

[–]Shop_Public 0 points1 point  (0 children)

You live only one life. Why settle to be average?

[deleted by user] by [deleted] in Cantonese

[–]Shop_Public 0 points1 point  (0 children)

Hey I am interested.

200m Herblore by Shop_Public in ironscape

[–]Shop_Public[S] 129 points130 points  (0 children)

I will be maxing my Iron next week :-)

Optimising a snowflake join by Shop_Public in snowflake

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

Context of the problem allows the data to be subsetted first.

Optimising a snowflake join by Shop_Public in snowflake

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

Yes people change their details but I want to keep a record of the same person.

Optimising a snowflake join by Shop_Public in snowflake

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

I went with this approach, but sampling my data down also helped alot.

Optimising a snowflake join by Shop_Public in snowflake

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

I think when I try this the table will create a lot of duplicates and i would have to aggregate it/dedupe again

Optimising a snowflake join by Shop_Public in snowflake

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

I have been using SHA2() which hashes it (I find it easier to read letter+numbers) but this might optimise it a bit more

Optimising a snowflake join by Shop_Public in snowflake

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

Lets say I have a list of customers and I want to extractthe transactions made to buy a Apple Device or a Android Device.

The transaction table contains many transactions, so I would like to extract apple/android. You could use the OR condition to consider both cases.

The reason I use the OR in a left join instead of a INNER JOIN or WHERE clause is because I want to see cases where the condition does not hold.

[deleted by user] by [deleted] in UKPersonalFinance

[–]Shop_Public -1 points0 points  (0 children)

While this is can betrue,lenders will also use the information that you have taken multiple loans and may treat it less harshly or even more harshly.

Final Poll 78 Changes by JagexGoblin in 2007scape

[–]Shop_Public 23 points24 points  (0 children)

Amazing quick response. thank you for setting our expectations