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 flexible stored procedures in Snowflake (using Javascript)— 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