Accelerating AI Insights: Snowflake-Powered Content Analysis

Client provides third-party content-level contextual analysis and brand safety solutions to publishers, DSPs, agencies and advertisers.

Challenges

  • Current system unable to cope with growing data size (in TBs) and not extensible due to flat structure​
  • Insights could be generated for limited number of days and any extended period resulted in system timeouts​
  • Generating new insights was complex and time consuming

Solution

  • Snowflake data warehousing enabled generating analytical insights at scale.​
  • Transitioned from Athena to Snowflake, utilized  Snowflake to deliver new MVPs, while migrating the rest in parallel.​
  • Leveraged curated data tables to optimize time-to-market by ensuring data readiness.​
  • Curtailed learning curve by reusing Apache Airflow to sync data between S3 and Snowflake.​
  • Tech Stack: ​
    • Pipelines: Apache Spark, Apache Airflow, AWS (Athena,S3, Redis, ECS) ​
    • Reporting: Google Looker, Docker​
    • API: Python

Impact Generated

  • 86% Boost New explore (Snowflake): < 8 seconds as compared to old explore (Athena Query): > 60 seconds​​
  • Scalable ​Transitioning from Athena to Snowflake enabled generating insights for a larger date range that previously resulted in timeouts with Athena​​
  • Extensible Curated tables enabling versatile usage across dimensions, supporting internal and customer-facing insights​
  • Seamless transition Ensured seamless transition with minimal disruption to ongoing operations​

Related Stories

Outperforming Competitors: AI-Driven Benchmarking for Superior Results

FDA-Approved Nerve Simulation Therapy: A MedTech Startup’s Success Story

Scalable Data Platform for Medical Device Leader

Trusted development partner

Zimetrics was an outstanding partner throughout the development of Iris, our rep ordering platform. Their team demonstrated a high level of professionalism and remained agile as we navigated challenges outside of their control. Communication was clear, consistent, and proactive at every stage of the project. Most importantly, they delivered a high-quality product that met our expectations and positioned us well for future growth. I would strongly recommend Zimetrics as a trusted development partner.

Jason Clark

Vice President & General Manager

Orascoptic

logo

The technology consistently delivered on its promises.

Earlier this year, I partnered with Zimetrics to integrate AI automation into our document review process for our car subscription service. I wholeheartedly endorse both Zimetrics, the Zimetrics team, and their top-tier tech. Our challenge was two-fold: 1. We needed AI to streamline our document processing for customer applications. 2. We wanted to enhance our digital customer experience. Zimetrics' 8Nap AI platform was the answer. The technology consistently delivered on its promises. The model training process, which often can be complex and intricate, was remarkably straightforward. The AI quickly adapted to the diverse documents we handle, maintaining high accuracy. Surprisingly, even with a modest set of example documents, we accomplished a thorough model training. The integration process was smooth, and the platform allowed for quick customizations to fit our specific needs, all while upholding strict security and compliance standards. Special credit goes to the Zimetrics team. Their expertise and professionalism shone through from day one. But it was their dedication to our needs that truly stood out. They ensured open communication, clear planning, and consistently met our timelines. In summary, I strongly recommend Zimetrics and their 8Nap AI platform. Their technology is impressive, and their team is a valuable partner to any business. I eagerly look forward to further incorporate their AI-powered automation technology into all our document-centric processes.

David Kaganovsky

Chief Technology Officer

GO Subscription

go

Genuine commitment to client success

Zimetrics consistently delivers outstanding customer service, combining responsiveness with a genuine commitment to client success. Their team is passionate about working with cutting-edge technologies and goes out of their way to support our software and teams. Within a relatively short period of working with them, we have been able to transition one of our functions completely to them.

Vaibhav Puranik

Sr. Vice President of Global Engineering

GumGum

gumgum

Big part of our success story

At Avation Medical, we truly value our partnership with Zimetrics. Their team brings a wealth of knowledge in all aspects of healthcare software including firmware, mobile apps, cloud data, DevOps and eCommerce, which greatly helped us with seamless integration. The team runs projects efficiently, independently and diligently, with clear understanding of business and patient needs. It has been my pleasure to work with Zimetrics, as they continue to be a big part of our success story.

Manish Vaishya

Chief Technology Officer

Avation Medical

avation

Professionalism and Expertise

Zimetrics has proven to be an excellent offshoring partner, providing us with skilled engineers from India. Their team's contributions have significantly enhanced our projects, and their professionalism and expertise have made collaboration seamless. We value our partnership with Zimetrics for the quality and reliability they bring to our extended team.

Ken Weiner

Chief Technology Officer

GumGum

gumgum

A partner who I can rely on

I have worked with Zimetrics to develop several very complex, customer-facing solutions, and in the process I've learned what makes Zimetrics valuable and rather unique as a software service provider. Zimetrics strives to create very engaged engineering teams that really understand what my business needs including my customers. And they have all the software service categories to handle most any problem I've asked them to solve, including application development, real-time cloud telemetry, manufacturing systems and embedded diagnostics. With Zimetrics I have a partner who I can rely on to deliver, and who invests in my company's successes for the long-term.

Brent Goldstein

Vice President, R&D - Software & Additive Products

Fresh Health

proclaim

Deep Expertise, Complete Ownership, Specialized Consulting

Zimetrics played an instrumental role in a high-tech solution for us, involving diverse Big Data technologies with high-performance engineering and web-scale considerations. Besides everything else, what stood out was their breadth of expertise, their deep skill level, and a comprehensive consultative approach with a keen customer success focus.

Vice President, Engineering & RnD Division

A Global Consumer Electronics Major

electronics

One word: Awesome!

Zimetrics partnered with us to build an analytics platform for our stealth mode startup, which aims to disrupt the call center industry. The experience of working with Zimetrics has been pure joy and the planning, timeliness, quality, thoughtfulness, cost and impeccable execution has put us on a very strong footing. I must also confess that it has been a personally very humbling experience for me, as before meeting the Zimetrics team, I used to consider myself to be an expert in Business Intelligence - Just Sign up!

Manish Panjiar

Founder & CEO

XTaaS Corporation

xtaas

Unlock faster growth & intelligence.

Connect Now