PinnedJoao Marques @ Data Beyond LtdinLevel 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?·10 min read·Jul 9, 2021--2--2
PinnedJoao Marques @ Data Beyond LtdinLevel Up CodingWhat Makes Snowflake So Much Better Than OthersTechnical overview of what makes Snowflake the best data platform out there·8 min read·Dec 28, 2020--2--2
Joao Marques @ Data Beyond LtdinLevel 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?·7 min read·Mar 16, 2023--2--2
Joao Marques @ Data Beyond LtdSQL Like a Pro: Query Tuning by ExampleIf you ever get fed up with queries that run for hours… this one’s for you!·5 min read·Feb 9, 2023----
Joao Marques @ Data Beyond LtdinLevel Up CodingIf You Really Must Use SQL Distinct…A Distinct is just like a group by (*)… except when it’s not!·6 min read·Oct 19, 2022--2--2
Joao Marques @ Data Beyond LtdCan You Have Too Many Joins? YES!Joins are databases’ “bread and butter”, but can you actually have “too many” joins? TLDR: yes!·5 min read·Jun 19, 2022----
Joao Marques @ Data Beyond LtdSQL Like a Pro: Please Stop Using Distinct!!Every time I see a “DISTINCT” I ask the same question: Why??·5 min read·Mar 27, 2022--16--16
Joao Marques @ Data Beyond LtdSQL Like a Pro: Query Tuning #1If you ever got fed up with queries that run for hours… this one is for you! #sql #tuning·5 min read·Feb 14, 2022--1--1
Joao Marques @ Data Beyond LtdSQL Like a Pro: Window FunctionsYou probably use window functions already… but have you taken them this far?·6 min read·Feb 7, 2022--1--1
Joao Marques @ Data Beyond LtdGet 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.·3 min read·Jan 16, 2022----