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
Practical Web and Network Concepts for Distributed System DevelopmentPhoto by Elshan Neymatov on UnsplashSep 10Sep 10
Spark vs Map-reduce: comparing the execution of a SQL query (part 1)Photo by Richard Lee on UnsplashSep 9Sep 9
SQL query execution: A Tutorial on Cost-based optimizationPhoto by Sammyayot254 on UnsplashAug 31Aug 31