PinnedData Saint Consulting IncDemystifying Apache Spark : SparkSession vs SparkContextPhoto by Jakub Skafiriak on UnsplashNov 13, 2023Nov 13, 2023
PinnedData Saint Consulting IncHow to Load Dimension TablesThe Basics: SQL MERGE, UPDATE and DELETE.Mar 10, 20233Mar 10, 20233
PinnedData Saint Consulting IncFour 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
PinnedData Saint Consulting IncDesigning 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
Data Saint Consulting IncPractical Web and Network Concepts for Distributed System DevelopmentPhoto by Elshan Neymatov on UnsplashSep 10Sep 10
Data Saint Consulting IncSpark vs Map-reduce: comparing the execution of a SQL query (part 1)Photo by Richard Lee on UnsplashSep 9Sep 9
Data Saint Consulting IncApache Hive’s evolution and Spark integrationPhoto by Taylor Vick on UnsplashSep 8Sep 8
Data Saint Consulting IncSQL query execution: A Tutorial on Cost-based optimizationPhoto by Sammyayot254 on UnsplashAug 31Aug 31
Data Saint Consulting IncAdvanced git questions for interviewPhoto by Farhat Altaf on UnsplashAug 5Aug 5