Alessandro PizziniHow to Get Started in Data Engineering: Essential Skills You NeedBreaking into data engineering can feel like navigating a maze of technologies and tools. But don’t worry, I’ve got your back! I’ve been…Jun 6Jun 6
Alessandro PizziniA Guide to Optimizing SQL Queries in BigQueryFoto di micheile henderson su UnsplashFeb 4Feb 4
Alessandro PizziniUnveiling the Power of Ranking Functions in BigQueryIn the dynamic landscape of SQL, ranking functions play a pivotal role in data analysis, offering a spectrum of tools to understand the…Jan 31Jan 31
Alessandro PizziniData Engineer’s Arsenal: 4 Must-Know SQL Window FunctionsFor a Data Engineer, the proficiency in SQL isn’t just a skill; it’s an essential tool that unlocks the ability to effortlessly manipulate…Jan 26Jan 26
Alessandro PizziniPython Data Pipeline: From IBM DB2 to Google BigQueryThe mission? Seamless, automatic data transfer from IBM DB2 FlashCopy straight into Google BigQuery using only Python.Oct 19, 2023Oct 19, 2023
Alessandro PizziniMonitoring Column Usage with SQLGlot: A Journey Towards Data Warehouse OptimizationIdentifying the Life-of-the-Party Columns: A Deep Dive into Optimizing Our Oracle Data Warehouse by Trimming the Fat with SQL QueriesOct 13, 20231Oct 13, 20231