The Challenge

A flagship streaming platform has been launched as part of global company’s push into the direct-to-consumer digital space. Using Snowflake for mission-critical subscriber data ingestion and Airflow for orchestration, this media company was experiencing  inconsistent performance, lengthy execution times, frequent SLA violations, and high run costs. This hindered business users from receiving timely insights to customer data changes, analyzing revenue performance, and performing subscriber analysis.

The Solution

Entrada collaborated closely with the client to deliver a multistep program, starting with PoC.

  • We rewrote Snowflake SQL into Spark SQL and leveraged  the Databricks Photon query engine.  
  • We Optimized their pipelines and tuned clusters with Delta Lake and Adaptive Query Execution.  
  • Using Databricks Workflows, we simplified scheduling, orchestrating, monitoring and alerting functions.  
  • Applied  predicate pushdown and file pruning techniques to reduce the amount of data scanned, resulting in increased processing  performance and consistency.

The Results

  • Daily delta pipelines for ingestion and transformation were streamlined and accelerated   
  • Data quality and reliability was improved by ensuring SLA compliance through improved handling of  data complexity and variability
  • Increased business agility and efficiency by providing timely and accurate insights to business stakeholders.  
  • Reduced  the operational overhead and costs of their data pipelines.

About Entrada
Entrada is a Databricks-focused consulting and implementation partner backed by Databricks Ventures. Entrada harnesses the power of Databricks to help customers accelerate their AI + data initiatives. Our expertise in AI/ML, Databricks, and analytics is centered around industry-centric solutions. Our mission is to simplify complex data + AI challenges and support end-to-end transformations, delivering future-ready solutions fast.

Other blog posts
Abstract gear and network visualization representing the Databricks FinOps cost control architecture covered in the article.

From Cost Visibility to Action: Scaling FinOps Intelligence with Databricks System Tables and Genie

This post walks through the architecture Entrada built around that observation, the Serverless Cost Control Accelerator, and, more importantly, the design principles behind it. Regardless os whether we’re a platform engineer, SRE, or FinOps lead trying to decide where to invest, the principles matter more than the product.

Read more
Abstract healthcare data architecture showing a secure medical research platform for imaging, clinical notes, and lab data on Databricks

Building Secure, AI-Ready Medical Research Platforms on Databricks

Research organizations need faster, more reliable ways to prepare sensitive data for analysis without loosening their grip on governance and privacy. Across the medical research platforms we’ve built on Databricks, the same patterns keep proving their worth: cleaner ingestion, standardized de-identification, simpler access to research-ready datasets, and a foundation that holds up when analytics and AI ambitions grow. Here’s what we’ve learned about designing these environments well.

Read more
Post cover "Lakebase: The Death of the Siloed Application Database" by William Guzmán Daugherty Data Engineer at Entrada

Lakebase: The Death of the Siloed Application Database

Every enterprise manages two separate, expensive database systems: OLTP for real-time transactions and OLAP for analytics. The pipeline connecting them is the most fragile thing in the entire stack. Databricks’ Lakebase makes that pipeline optional, offering a strategic opportunity to collapse two stacks into one and finally deliver the near-real-time data that critical business applications need.

Read more
Show all posts
GET IN TOUCH

Millions of users worldwide trust Entrada

For all inquiries including new business or to hear more about our services, please get in touch. We’d love to help you maximize your Databricks experience.