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, 20233Mar 10, 20233
PinnedFour SQL anti-patterns: Avoid them!The following best practices provide guidance on avoiding query anti-patterns that impact performance in BigQuery.Apr 4, 20231Apr 4, 20231
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