dbx for local and rapid development lifecycle through Databricks Posted on July 10, 2023, updated on July 10, 2023 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 Continue reading
How to online refresh BI tables with minimum impact to end users Posted on May 10, 2023, updated on May 10, 2023 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 Continue reading
Citus columnar storage hands-on Posted on March 28, 2023, updated on March 28, 2023 by Yannick JaquierTable of contents Preamble Citus installation Citus columnar storage testing preparation Citus columnar storage testing results References Continue reading
Table and scalar SQL macros hands-on Posted on March 3, 2023, updated on March 20, 2023 by Yannick JaquierTable of contents Preamble Table SQL Macros Scalar SQL Macros Conclusion References Continue reading
Database Resident Connection Pooling (DRCP) hands-on Posted on January 28, 2022, updated on January 25, 2022 by Yannick JaquierTable of contents Preamble Database Resident Connection Pooling creation Database Resident Connection Pooling testing References Continue reading
PHP OCI8 and PDO_OCI extensions installation to access Oracle Posted on October 28, 2021, updated on October 25, 2021 by Yannick JaquierTable of contents Preamble OCI8 from pecl PDO_OCI OCI8 from PHP source References Continue reading