{{ conf.get('reid') }}

data platform engineer @ hinge

[{{ conf.get('reid') }} @slimebwoy]

@JohnKutay This is so beautifully vague

[{{ conf.get('reid') }} @slimebwoy]

@s8n

[{{ conf.get('reid') }} @slimebwoy]

This sql is not going to fluff itself

[{{ conf.get('reid') }} @slimebwoy]

Would the where statement create the factorial of the %test% (24 different approaches) like [test, Test, TEst, TESt, …]? Would snowflake cast the col1 to upper/lower and look like that? I feel like ilike is very inefficient but I don’t really get what’s happening under the hood.

[{{ conf.get('reid') }} @slimebwoy]

@teej_m friends and I were discussion snowflake query optimizations (as per usual) and figured I’d ask you the question. If I had a column (‘col1’) that is varchar and there are 1,000 rows of it. How many scans would “where col1 ilike ‘%test%’” produce?

[{{ conf.get('reid') }} @slimebwoy]

Come on

[{{ conf.get('reid') }} @slimebwoy]

Coolest part of #HOTD so far is the iron throne’s melted swords.

[{{ conf.get('reid') }} @slimebwoy]

@matsonj The function in the second where statement gets run for every row?

[{{ conf.get('reid') }} @slimebwoy]

@tcollier7 Just to feel something 😮‍💨🥺

[{{ conf.get('reid') }} @slimebwoy]

@moi__bueno He the goat

[Tim Bray @timbray]

Dear people writing code: Never create a class/file/package with “utilities” in its name. You are opening an escape hatch for people trying to avoid thinking about where things should go. It will inevitably grow to become a sprawling, misshapen, widely-hated monster.

[{{ conf.get('reid') }} @slimebwoy]

@brotherlott Need me to drop a thirty bomb on valorant for the stream?

[{{ conf.get('reid') }} @slimebwoy]

@DylanWa68690046 In the bleak midwinter

[{{ conf.get('reid') }} @slimebwoy]

I agree. When Ive been asked the tech question I relate it to music. “I want to learn music”… okay like learning how to play an instrument? A style of music? The theory behind it? It’s too broad of a statement.

[{{ conf.get('reid') }} @slimebwoy]

@g_xing @SnowflakeDB What is your definition of warehouse native apps? I’m curious of this as well.

[{{ conf.get('reid') }} @slimebwoy]

@tamurphy Scratch is the future. I read the hacker news too

[{{ conf.get('reid') }} @slimebwoy]

@kateb0sh I also have every home shake album downloaded for when I fly. Idk why. I’m not like the hugest fan but it’s good stuff

[{{ conf.get('reid') }} @slimebwoy]

Do you keep 500 tabs of SQL queries or one mega tab with 5000 lines of SQL queries? ❄️

[{{ conf.get('reid') }} @slimebwoy]

@emztho need a thread of excellent car license plate photos pleaz

[{{ conf.get('reid') }} @slimebwoy]

@FleetwoodEdd Sounds amazing. Gonna have to try that. Does baking work as well or grilling only?