PinnedDemystifying Apache Spark : SparkSession vs SparkContextPhoto by Jakub Skafiriak on UnsplashNov 13, 2023Nov 13, 2023
PinnedHow to Load Dimension TablesThe Basics: SQL MERGE, UPDATE and DELETE.Mar 10, 2023A response icon3Mar 10, 2023A response icon3
PinnedFour SQL anti-patterns: Avoid them!The following best practices provide guidance on avoiding query anti-patterns that impact performance in BigQuery.Apr 4, 2023A response icon1Apr 4, 2023A response icon1
PinnedDesigning an ETL: Kimball’s 34 SubsystemsThe Kimball Group has carefully restructured ETL best practices into 34 subsystems that represent the key ETL architecture components…Mar 2, 2023Mar 2, 2023
Product Analytics: Academic Guide Based on the book “Lean Analytics”Photo by Deng Xiang on UnsplashAug 10Aug 10
Functional vs Object-Oriented Programming for Non-CS ScientistsPhoto by Nick Design on UnsplashAug 5Aug 5
End-to-End Setup for Scala Pipeline and CI/CD on Windows for Python DevelopersThis runbook provides a detailed, phased approach for Python developers setting up Scala pipeline development and CI/CD on a Windows…Jul 11Jul 11
