Lakehouses, Data Warehousing, Big Data and Advanced Analytics
This blog outlines a straightforward approach to automating email notifications with SQL output attachments using Databricks. It highlights the limitations of native alerts for specific scenarios and presents a customizable method involving metadata mapping, dynamic queries, and email functionality. The goal is to share insights for potentially scalable solutions.
Hey folks, long time no speak – it’s been a crazy amount of time since my last blog, so it’s great to get back into
This article, part of a series focused on Healthcare analytics, discusses how Databricks can be used to effectively manage interoperability in healthcare systems. By leveraging standardized protocols, such as FHIR and OMOP, Databricks offers complex analytics, data processing, and real-time decision making. It also presents a toolkit developed to solve FHIR-specific challenges. The article includes a demo showing how to ingest and parse FHIR bundles, and transform them into standardized tables ready for analysis.
I’ve always been a fan of data virtualisation. I know it’s not the silver bullet for every kind of data integration scenarios (I still love
It’s been a couple of months since my last post and that’s largely down to the fact that I’ve done something I never imagined doing
Change Data Capture (Referred to as CDC for the rest of this article) is a common pattern used to capture change events from source databases
SQL Of The North 