PinnedMichaël MénachéAn introduction to Dynamic SQL in BigQueryStored Procedures in BigQuery (and in SQL in general) are a useful tool… but lack flexibility compared to what exists in other languages…Jan 26, 20221Jan 26, 20221
Michaël MénachéAn introduction to Dynamic SQL in Snowflake — Part 1Tired of writing the same bits of code all over again? This step-by-step guide on how to make flexible Stored Procedures in Snowflake is…Feb 6Feb 6
Michaël MénachéThe complete guide to creating columns based on multiple conditions in a Pandas DataFrameWant to know the best way to to replicate SQL’s Case When… logic (or SAS’s If… then… else…) to create a new column based on conditions in a…Jul 16, 20222Jul 16, 20222
Michaël MénachéAn introduction to git for personal projects — How I built my own DIY Covid dashboard for freeA little story and guide on how to use Git and Python to build a simple DIY dashboard for those who never used Git beforeJun 19, 2022Jun 19, 2022
Michaël MénachéAn introduction to Dynamic SQL in BigQuery — Part 2: flow control and loopsIn Part 1, we saw the basic syntax for Dynamic SQL, now let’s focus on flow control and loops: a useful set of tools to make your Stored…Feb 19, 20221Feb 19, 20221