Description
Takeda’s Plasma Derived Therapies (PDT) business unit has recently embarked on a project to use Spark Streaming on Databricks to empower how they deliver value to their Plasma Donation centers. As patients come in and interface without clinics, we store and track all of the patient interactions in real time and deliver outputs and results based on said interactions. The current problem with our existing architecture is that it is very expensive to maintain and has an unsustainable number of failure points. Spark Streaming is essential for allowing this use case because it allows for a more robust ETL pipeline. With Spark Streaming, we are able to replace our existing ETL processes (that are based on Lamdbas, step functions, triggered jobs, etc) into a purely stream driven architecture. Data is brought into our s3 raw layer as a large set of CSV files through AWS DMS and Informatica IICS as these services bring data from on-prem systems into our cloud layer. We have a stream currently running which takes these raw files up and merges them into Delta tables established in the bronze/stage layer. We are using AWS Glue as the metadata provider for all of these operations. From the sta…
Description from YouTube. Full content on the video page.
More from Databricks
NewsDatabricks for Good x MapAid: Creating a Searchable Database for Groundwater Discovery
MapAid is using Databricks to build an AI groundwater mapping system called Well Mapper that processes water documents to identify accurate well-drilling locations in Ethiopia, improving on the current 30% success rate. The system analyzes 400 well logs in half a second instead of four weeks, with potential to double Ethiopia's food supply through improved irrigation.
NewsHow Databricks Genie Automates Data Workflows with Genie Ontology and Scheduled Tasks
Databricks Genie enables ontology by default for business context and adds document/PDF uploads, direct Unity Catalog queries, and team collaboration features in chat. Scheduled tasks automate recurring workflows with embedded visualizations and PDF outputs accessible across web, desktop, and mobile platforms.
NewsGenie One Beginner's Guide: Explore Data & Automate Tasks
Genie One helps subject matter experts avoid repetitive questions by using business ontology to understand your data and run real-time queries that generate instant answers and shareable reports. The tool can also automate monitoring with conditional alerts that only notify you when specific business thresholds are met.
TutorialsHow to Schedule Automated Meeting Prep in Genie One
Genie One allows users to connect multiple data sources like Databricks tables and Google Calendar, then create analyses through natural language prompts to prepare for customer meetings. The platform can schedule these analyses to run automatically on a recurring basis and deliver results via email or mobile app.
TutorialsHow to Build Custom Skills in Genie One in Minutes
Genie 1 can populate business report templates by analyzing their format and running SQL queries against organizational data. Users can save these report workflows as reusable skills that execute with a single slash command, enabling automation of recurring reports.
TutorialsHow to Create & Share Polished Documents in Genie One
Genie One documents enable creation of polished reports with AI-generated narratives and interactive charts sourced from Databricks data. The feature supports real-time collaborative editing between users and Genie, sharing with team members for comments, and scheduling automated report generation.