Skip to content

irfanghat/Databricks-Hackathon-Nov-2025

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Databricks for Industrial Automation - Hackathon Overview

What We're Showcasing

A complete end-to-end industrial IoT solution that transforms Databricks into a real-time predictive maintenance and monitoring platform for manufacturing environments. This demonstrates how Databricks can bridge the gap between operational technology (OT) and information technology (IT) in industrial settings.

The Problem

Manufacturing facilities generate massive amounts of real-time sensor data from PLCs, pumps, compressors, and other equipment, but:

  • Data remains siloed in industrial control systems
  • Unexpected equipment failures cause costly downtime
  • Reactive maintenance instead of predictive
  • No unified view of operational health
  • Difficulty scaling insights across multiple facilities

Solution

A production-ready architecture that connects OPC UA industrial sensors directly to Databricks, enabling:

Real-Time Data Ingestion

  • Stream live telemetry from industrial equipment (temperature, vibration, pressure, energy consumption)
  • Secure OPC UA connectivity with certificates managed in Unity Catalog Volumes
  • Automatic storage in Delta Lake for time-series analytics

Intelligent Monitoring & Anomaly Detection

  • Real-time threshold monitoring (warning/critical alerts)
  • Trend-based forecasting to predict threshold violations before they occur
  • Multi-sensor correlation for equipment health scoring

Predictive Analytics with MLflow

  • Train time-series forecasting models on historical sensor data
  • Deploy models to Databricks Model Serving for real-time predictions
  • Predict equipment failures hours or days in advance

Interactive User Experience

  • Live Dashboard: Real-time visualization of sensor readings, anomalies, and predictions
  • Conversational AI Chatbot: Natural language queries like "What is the predicted vibration for Pump 2?" or "Show metrics that exceeded thresholds this morning"

Technical Architecture

OPC UA Sensors (Industrial Equipment)
          ↓
databricks-industrial-automation-suite (Python Client)
          ↓
Delta Lake (Unity Catalog) - factory_telemetry table
          ↓
MLflow Training & Model Registry
          ↓
Databricks Model Serving (Real-time Inference)
          ↓
Streamlit/Dash Dashboard + LLM-Powered Chatbot

Key Differentiators

  1. Enterprise Security: Leverages Unity Catalog for certificate management and governance
  2. Real Production Protocol: Uses OPC UA (implentations for other protocols is in progress), the industrial standard for automation
  3. Predictive, Not Reactive: Forecasts issues before they cause downtime
  4. Conversational Analytics: Natural language interface for operational teams
  5. Fully Integrated: Single platform for ingestion, storage, ML, and visualization

Demo Flow

  1. Connect to live OPC UA manufacturing server
  2. Stream real-time sensor data (pumps, compressors, quality control)
  3. Detect anomalies as they occur (threshold violations)
  4. Predict future failures using trained ML models
  5. Interact with chatbot to query equipment status naturally
  6. Visualize everything in a live dashboard

Business Impact

  • Reduce unplanned downtime through predictive maintenance
  • Extend equipment lifespan with optimized maintenance schedules
  • Scale across facilities with centralized data governance (Unity Catalog)
  • Democratize insights - operators can ask questions in plain English (Databricks Genie & Databricks RAG Agents)
  • Faster time-to-value - pre-built integrations with industrial protocols (Industrial Automation Suite)

This example could serve as a blueprint for Industry 4.0 transformation on Databricks.

Previews

Industry Plant Genie Room

  • Industry Plant Operators & Business Analysts can analyze Plant Data via Natural Language.

Genie Room Preview

Industry Plant Dashboard Preview

  • Click the image to open the live interactive dashboard.

Dashboard Preview

About

Submission for the Databricks Free Edition Hackathon held in November 2025.

Topics

Resources

Stars

Watchers

Forks

Packages

 
 
 

Contributors