PinnedData Saint Consulting Inc·Nov 13, 2023Demystifying Apache Spark : SparkSession vs SparkContextPhoto by Jakub Skafiriak on Unsplash
PinnedData Saint Consulting Inc·Mar 10, 2023How to Load Dimension TablesThe Basics: SQL MERGE, UPDATE and DELETE.A response icon3A response icon3
PinnedData Saint Consulting Inc·Apr 4, 2023Four SQL anti-patterns: Avoid them!The following best practices provide guidance on avoiding query anti-patterns that impact performance in BigQuery.A response icon1A response icon1
PinnedData Saint Consulting Inc·Mar 2, 2023Designing an ETL: Kimball’s 34 SubsystemsThe Kimball Group has carefully restructured ETL best practices into 34 subsystems that represent the key ETL architecture components…
Data Saint Consulting Inc·May 10The IESO 10-Zone Ontario Network Model – ExplainedPhoto by Andrey Metelev on Unsplash
Data Saint Consulting Inc·Dec 9, 2025End-to-End Guide: Upgrading and Modernizing Data Quality Rules in Legacy ETL PipelinesIntroduction
Data Saint Consulting Inc·Nov 19, 2025🚀 Scaling Spark Like a Pro: How to Configure Databricks Clusters for a 500-GB Job Without Wasting…If you’ve ever tuned a Databricks job that chews through hundreds of gigabytes, you know the dance: over-provision and Finance hunts you…
Data Saint Consulting Inc·Nov 16, 2025A Tale of Two Table Lifecycles: Cloudera External Hive vs. Databricks Unity Catalog DeltaPhoto by Dextar Vision on Unsplash
Data Saint Consulting Inc·Aug 10, 2025Product Analytics: Academic Guide Based on the book “Lean Analytics”Photo by Deng Xiang on Unsplash
