PinnedPublished inLevel Up CodingSnowflake vs BigQuery: Clash of Titans (Part 1)Snowflake and BigQuery are similar in many ways, and one could think it would be an easy and balanced fight between them… but is it though?Jul 9, 20212Jul 9, 20212
PinnedWhat Makes Snowflake So Much Better Than OthersTechnical overview of what makes Snowflake the best data platform out thereDec 28, 20202Dec 28, 20202
Published inLevel Up CodingSnowflake vs Redshift Serverless: Is this really the best you got?After years of using Snowflake, I was “forced” to use Redshift Serverless with proper big data. What did I find?Mar 16, 20232Mar 16, 20232
SQL Like a Pro: Query Tuning by ExampleIf you ever get fed up with queries that run for hours… this one’s for you!Feb 9, 2023Feb 9, 2023
Published inLevel Up CodingIf You Really Must Use SQL Distinct…A Distinct is just like a group by (*)… except when it’s not!Oct 19, 20222Oct 19, 20222
Can You Have Too Many Joins? YES!Joins are databases’ “bread and butter”, but can you actually have “too many” joins? TLDR: yes!Jun 19, 2022Jun 19, 2022
SQL Like a Pro: Please Stop Using Distinct!!Every time I see a “DISTINCT” I ask the same question: Why??Mar 27, 202216Mar 27, 202216
SQL Like a Pro: Query Tuning #1If you ever got fed up with queries that run for hours… this one is for you! #sql #tuningFeb 14, 20221Feb 14, 20221
SQL Like a Pro: Window FunctionsYou probably use window functions already… but have you taken them this far?Feb 7, 20221Feb 7, 20221
Get Your Data Lineage Out of Snowflake in 2 Minutes… For Free!Snowflake is just about to release something that looks like nothing, but is kind of awesome! Watch out for Bundle 2021_10.Jan 16, 2022Jan 16, 2022