CUSTOMER STORIES
Tampa Bay Rays Accelerate Time to Value by 75% with Snowflake and Coalesce
With Snowflake and Coalesce, the Tampa Bay Rays leverage data to enhance the fan experience, drive revenue and improve stadium operations.
4xAccelerated migration time
1,500Lines of code automated per transformation
Industry
Advertising, Media & Entertainment, Financial Services, Healthcare & Life Sciences, Manufacturing, Retail & Consumer Goods, TechnologyLocation
San Francisco, CAStory highlights
- Accelerating time to value from months to weeks: By combining Snowflake’s AI Data Cloud with Coalesce’s transformation capabilities, the Tampa Bay Rays replicated their entire on-premises infrastructure in the cloud — slashing expected migration time from six months to just six weeks.
- Strengthening business insights, data integrity and stakeholder trust: By establishing a verified and consistent single source of truth, Snowflake and Coalesce restored the Rays' organization-wide confidence in data analytics, empowering the front office to decisively drive fan experience, revenue initiatives and stadium operations.
- Making the Ray’s data infrastructure future-ready for years to come: While the Rays have no control over how the league (MLB) stores or formats essential centralized data, the team can now flexibly ingest and transform this data regardless of its raw state thanks to their new scalable and agile cloud architecture.
Video Transcript
[00:00 - Off-camera crew conversation]
Crew: Sound. Brennan DiChiara: [Claps clapboard] That was it. Crew: Yeah, we got it.
[00:07]
Brennan DiChiara: One of our biggest data sources that we actually pull in data from comes from data that is centralized within Major League Baseball. At the teams, we don't really have control over where they store that data. So, we wanted a platform that would allow us to adapt no matter where they were storing it.
[00:19]
Brennan DiChiara: I'm Brennan DiChiara. I'm our Vice President of Business Strategy and Analytics for the Tampa Bay Rays. We work with all of our departments and the front office outside of the baseball field to ultimately improve the fan experience, drive revenue, improve stadium operations.
[00:37]
Brennan DiChiara: We use Snowflake for our data warehouse, and part of that process that my team owns is the ELT process—so extracting, loading, and transforming data so that it goes from its raw form into our warehouse, ultimately back into visualizations that we share with stakeholders. Coalesce plays a key role for us in the transformation of that data.
[01:03]
Brennan DiChiara: Our goal was to move our data warehouse from on-premises into the cloud with Snowflake. Our first big milestone was, "Let's replicate everything that we have on-premises in the cloud." There are a lot of data transformation processes that we had on-prem that required 1,500 lines of code to get the data from its raw form to what we needed it to be. Originally, our goal was to get everything rebuilt in the span of six months, and with Coalesce, we were able to get it done in six weeks.
[01:26]
Brennan DiChiara: Snowflake and Coalesce have done a ton for us in the way of increasing credibility with our department. A lot of teams within the organization rely on us for this data to be correct, and when it's incorrect, it can be difficult. It's really allowed the organization to have that single source of truth and, "Hey, this is the number we're going with, we feel confident in it."
