Snowflake EDW Implementation for low latency insights from fast growing data of an e-discovery platform

The client is a leading provider of e-discovery software solutions that manage the growing data volumes rising with new information sources. The company partnered with Trianz to develop an EDW with advanced analytics capabilities for their industry-leading SAS Legal software product that can be used by attorneys to build their cases.

Business Challenge

The client’s legal application deals with large volumes of diverse information types including documents, pictures, emails, past case history, etc., which attorneys can use as support to build their case. A case in point was Telemetry data on the usage of the product which became humongous, capturing information on every action happening on the SAS tool. Their current EDW solution is not able to handle this fast-growing data volume and had a difficult time processing and providing insights from this data.

Technology Components

  • Snowflake EDW

Approach

  • Trianz built an SQL-based EDW solution with analytics capabilities for the client earlier.

  • Having a clear insight into the client’s business and its EDW solution, Trianz recommended Snowflake to support the Telemetry use case and built the POC, demonstrating efficiency.

  • Trianz was engaged to migrate the Telemetry data from the existing SQL Server EDW to Snowflake with an overall objective of migrating the complete EDW data to Snowflake.

Transformational Effects

  • Seamlessly moved entire EDW from SQL Server to Snowflake.

  • With the elasticity of the cloud, Snowflake EDW can now handle large data volume well and process it within minutes to provide insights.

Contact Us Today

By submitting your information, you agree to our revised  Privacy Policy.

TESTIMONIALS

Get in Touch

Let us help you
transform and grow


Let’s Talk

x

Status message

We're eager to assist you! Please leave a message and we'll get back to you shortly.

By submitting your information, you agree to our revised  Privacy Policy.