Change Data Feed to track changes at row level Posted on December 20, 2023 , Modified on August 25, 2025 , by Yannick JaquierTable of contents Preamble Change Data Feed testing Change Data Feed testing with Spark Structured Streaming References Read more Databricks Development Leave a comment
Auto loader to process flow of raw files hands-on Posted on November 30, 2023 , Modified on January 19, 2024 , by Yannick JaquierTable of contents Preamble Auto Loader test case Auto Loader testing References Read more Databricks Development Leave a comment
dbx for local and rapid development lifecycle through Databricks Posted on July 10, 2023 , Modified on October 12, 2026 , by Yannick JaquierTable of contents Preamble Not able to access DBFS files under Databricks Connect Creation of the DBR 12.2 Conda environment DBX installation and configuration Databricks CLI installation Databricks CLI profile configuration DBX installation DBX configuration DBX execution Resolve unicode error and add icons to Git Bash DBX execution of a more complex example Synchronize your local code with Databricks References Read more Databricks Development Leave a comment
How to online refresh BI tables with minimum impact to end users Posted on May 10, 2023 , Modified on October 13, 2026 , by Yannick JaquierTable of contents Preamble Preparation of the test environment The old legacy technique The alter table switch technique The view technique The synonym technique The schema transfer technique Conclusion References Read more MariaDB, MySQL, Oracle, PostgreSQL, SQL Server Development, SQL Leave a comment
Citus columnar storage hands-on Posted on March 28, 2023 , Modified on March 10, 2026 , by Yannick JaquierTable of contents Preamble Citus installation Citus columnar storage testing preparation Citus columnar storage testing results References Read more PostgreSQL Development, Tuning 1 comment
Table and scalar SQL macros hands-on Posted on March 3, 2023 , Modified on March 20, 2023 , by Yannick JaquierTable of contents Preamble Table SQL Macros Scalar SQL Macros Conclusion References Read more Oracle Development, SQL Leave a comment