Daniel AnyaAtomicity for Data EngineersAtomicity, in a program or system, is the concept of treating the executions of more than one operation as if they were executed as a…Aug 30, 2022Aug 30, 2022
Daniel AnyainTowards DevRewriting Window Functions with Joins in SQLYou might find yourself stuck in a database/query engine without support for window functions(mysql 5.7 and less 👀) or in a SQL interview…Jan 18, 2022Jan 18, 2022
Daniel AnyaDuplicate record management in SnowflakeHere’s a pattern for deduplicating tables with duplicate rows in Snowflake. The queries below assume that your user or role has CREATE…Dec 23, 2021Dec 23, 2021
Daniel AnyaThe `getattr` function in PythonThe getattr function is a Python built-in function that every Python programmer should have in their OOP box of tools. There are a variety…Dec 20, 20211Dec 20, 20211
Daniel AnyaWhat makes a good Product Manager?I used to be a product manager at a previous job. It was a fascinating role that taught me a lot about how tech companies work, how…Sep 6, 2020Sep 6, 2020
Daniel AnyaUnbias a biased Coin with PythonRemoving the bias from a biased coin is a nice probability question that shows up sometimes in data analyst or data scientist interviews…Jul 18, 2020Jul 18, 2020