Case Studies

Snowflake to Databricks Migration for a Retail Subscription Platform

Industry

Retail Tech

Core Technologies

DatabricksDelta LakeGenieSQLUnity Catalog

Client Overview

The client is a fast-growing direct-to-consumer (D2C) meal-kit and grocery subscription company operating across multiple regions. The business manages subscription commerce, customer personalization, inventory planning, cold-chain logistics, and fulfillment using a cloud-based data platform that supports analytics and machine learning.

TL;DR

Learn how a fast-growing meal-kit subscription company modernized its cloud data platform by migrating from Snowflake to Databricks, improving analytics performance, simplifying machine learning workflows, and preparing for future AI-driven growth.

With Lucent Innovation supporting the migration, the company brought key data workloads together, improved access to timely insights, and built a scalable foundation for continued growth across markets and future AI initiatives.

Challenges

As the business expanded into new markets, the amount of data flowing through the platform grew quickly. Subscription activity, customer preferences, delivery operations, recipe data, and supply-chain information all needed to be processed at a much larger scale.

Snowflake was already supporting the company’s analytics needs, but the growing mix of analytics, machine learning, and operational data meant the team wanted a more unified environment. Managing different data workflows separately was gradually adding more effort to day-to-day operations.

The company also needed faster access to fresh data. Logistics teams depended on timely information for deliveries and cold-chain monitoring, while analytics teams needed updated data to understand subscriptions, customer behaviour, and business performance.

The organization wanted a unified lakehouse architecture capable of supporting analytics, data engineering, streaming workloads, and machine learning from a single platform instead of maintaining separate processing environments.

At the same time, machine learning was becoming a bigger part of the platform, particularly for recipe recommendations and customer insights. The next step was therefore not simply handling more data, but creating a foundation where analytics, operational data, and machine learning could grow together without adding unnecessary complexity.

Solution

Lucent Innovation worked with the company to plan and carry out the move from Snowflake to Databricks in phases, keeping the transition manageable while the business continued to operate across multiple markets. As part of its Databricks migration and optimization services, the team reviewed existing workloads and prioritized subscription, customer, logistics, and supply-chain data for migration.

The new Databricks environment was structured using a Bronze, Silver, and Gold architecture. Raw data entered the Bronze layer, was cleaned and organized in the Silver layer, and then prepared in the Gold layer for reporting, analytics, and machine learning. This gave teams access to data in the form they needed while keeping the overall flow consistent and easier to scale.

The next step was bringing analytics, data processing, and machine learning workflows into a more connected environment. This made it easier for different teams to work with the same data without maintaining several separate processes.

Data pipelines were also reorganized so fresh information could reach teams sooner. Logistics teams gained quicker access to delivery and cold-chain data, while business teams could work with more current subscription and performance insights.

Finally, machine learning workflows for recipe recommendations and customer insights were brought closer to the wider data platform, creating a stronger foundation for expanding AI and analytics as new use cases emerge.

Technologies and Tools

Platform

Databricks Lakehouse

Storage Format

Delta Lake on AWS S3 (open Parquet; time-travel enabled)

Streaming Ingestion

Apache Kafka + Databricks Auto Loader (Structured Streaming)

Batch Ingestion

AWS DMS + Auto Loader (CDC from PostgreSQL / MySQL)

Transformation

dbt Core (Databricks adapter) + PySpark

Orchestration

Databricks Workflows (DAG-based, cluster lifecycle managed)

ML Training

Databricks ML Runtime + MLflow (GPU clusters for deep learning)

Feature Store

Databricks Feature Store + DynamoDB (offline + online serving)

Model Serving

Databricks Model Serving — serverless REST endpoints

Analytics & Reporting

Databricks SQL Serverless + Power BI / Tableau

Infrastructure as Code

Terraform (hybrid AWS + Azure deployment)

Governance

Unity Catalog — unified data, model, and feature lineage

Security

Okta SSO + Unity Catalog RBAC + VPC — SOC 2 Type II compliant

Results

  • 30% faster data processing across subscription, logistics, and reporting workloads.

  • 35% reduction in reporting time, giving teams quicker access to updated business insights.

  • 28% lower data processing overhead through streamlined pipelines and a unified data environment.

  • Simplified analytics, data engineering, and machine learning workflows within one platform.

  • Improved access to fresh logistics and cold-chain data for faster operational decisions.

  • Made recipe recommendations and customer insight workflows easier to scale and manage.

  • Created a flexible data foundation for new markets, higher data volumes, and future AI use cases.

Words of Appreciation

"Lucent Innovation made the migration feel well planned from the start. Their team understood how our data supported different parts of the business and helped us move to Databricks without making the process unnecessarily complex. We now have a more connected setup for analytics, reporting, and machine learning, with a stronger foundation to support future growth."

Aaron Mitchell

Chief Technology Officer

Future Scalability

With Databricks in place, the company can continue expanding its data capabilities as the business grows. The platform can support higher data volumes, new geographies, more advanced recommendation models, real-time operational insights, and future AI use cases without requiring a major rebuild of the underlying data environment.

Frequently Asked Questions

Still have Questions?

Let’s Talk

Why would a company migrate from Snowflake to Databricks?

arrow

How do you migrate a data warehouse without disrupting the business?

arrow

What does a production Databricks lakehouse stack actually include?

arrow

What performance gains come from moving to a lakehouse architecture?

arrow

Does a lakehouse make machine learning easier to run?

arrow