Hey folks, long time no speak! (Technically only a month, ish, but good to be back regardless) So, for those who know me, you’ll know
Getting Started with Unity Catalog Metric Views
The post discusses the significance and creation of Metric Views in Databricks, emphasizing their role in standardizing key performance indicators across tools while simplifying user experience. It covers the benefits of Metric Views, the use of SQL for creation, and offers various examples and extensions to demonstrate advanced implementations for complex data analysis scenarios.
Data-driven Notifications with Databricks
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.
Transforming T-SQL (or any dialect) to Databricks with AI_QUERY: A Step-by-Step Guide
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
Delivering Interoperability For Analytics in Healthcare with Databricks (Part 1 – Ingestion & Analysis)
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.
Lakehouse Federation – Data Virtualisation for the Databricks Age
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
SQL Of The North 