PinnedJamie ThomsonMy dev setup — March 2022I’m one of those people that likes to peer at other people’s screens to see what apps they’ve got pinned in their taskbar/dock, what…Mar 5, 20224Mar 5, 20224
Jamie ThomsonRecursively get all users that have been granted a Snowflake roleIts easy in Snowflake to know which users have been granted a role:Jul 1Jul 1
Jamie ThomsonSubclass airflow operators to make parameters templateableI recently encountered a problem when developing an airflow DAG that I solved by subclassing the operator that I was using.Apr 141Apr 141
Jamie ThomsonTIL: Ignore git changesSomething I discovered recently that I’m recording here because I know I’ll need it in the future. Thank you to my colleague Jon Grace-Cox…Feb 5Feb 5
Jamie ThomsonVSCode devcontainer with zsh, oh-my-zsh and agnoster themeI’m a fan of Visual Studio Code devcontainers and recently I’ve worked on getting them setup just how I like them withMay 8, 20232May 8, 20232
Jamie ThomsoninHelloTechHow HelloFresh created a smooth onboarding experience for engineersI joined HelloFresh as a data engineer in January 2023 and since then I’ve become familiar with the ways of working within HelloTech (the…Mar 23, 2023Mar 23, 2023
Jamie ThomsonTIL: SELECTing arrays in BigQuery to be INSERTed into repeated columnsToday I had a need to insert data into a BigQuery table containing columns that were REPEATABLE, meaning that the column itself contains…Oct 22, 2022Oct 22, 2022
Jamie ThomsonHandy use of walrus operator to satisfy mypyI had an issue today where mypy was complaining about the following code which uses re.search inside of a set comprehension:Jul 22, 2022Jul 22, 2022
Jamie ThomsonSelect python interpreter in poetryI recently started working on a python codebase that is stored in a git repository. We use pre-commit in this git repository to run various…Jun 15, 20221Jun 15, 20221
Jamie ThomsonWhat to do about BigQuery error “Resources exceeded during query execution”Here at MoneySupermarket we use Google Cloud BigQuery to power our data analytics and I think its fair to say we push it to its limits…Apr 21, 2022Apr 21, 2022