ThoughtSpot Migration

Improving the power of ThoughtSpot while drastically reducing infrastructure costs by migrating from ThoughtSpot Falcon to Embrace.

Customer Story At a Glance:

Industry: Business Services
Use Case: Migration
Key Tech: ThoughtSpot, Snowflake

The Results:

• ETL and Data Modeling. Simplified process and improved automation.
• Performance, Flexibility, & Scalability. Falcon requires server upgrades and downtime. Embrace scales up/down in minutes.
• Costs Savings on Infrastructure. Less RAM requirements and a “not always on” approach.
• Real-time capabilities. Reload minimums from an hour to minutes, enabling new insights.
  

About the Customer

A business services firm with a global mindset. Services range from human resources and talent to facilities and maintenance to financial strategy and support – from Business Intelligence to systems literacy; from legal counsel to strategic communications – and just about anywhere in between.

Why ThoughtSpot

ThoughtSpot allows the customer to analyze massive quantities of data. Tables such as mailing data had over 5 billion records, which made it impossible to analyze efficiently in any other BI tool. Also, they have end users of various skill levels. ThoughtSpot made it easy for those users to adopt the tool more quickly than other BI tools.

The Challenge

The customer's massive ThoughtSpot Falcon environment spans 10+ nodes in AWS. Their current infrastructure costs were getting out of control. The majority of use cases did not require the maximum performance but the larger tables locked Falcon in at the higher level.

The Solution

With the help of SME, the customer explored options around how to reduce costs while keeping the same ThoughtSpot performance level. The first option would have been to introduce server scheduling. This was not plausible because they have users across the world.

The second option was to migrate from Falcon to Embrace and connect to their Snowflake cloud data warehouse. The migration option was chosen as the solution because:

• Embrace has far less RAM requirements.
• Potential to reduce footprint to one server in cloud environment.
• Relevant data had already been consolidated in Snowflake.

By moving from Falcon to Embrace on ThoughtSpot Cloud, the customer would not have to manage any servers in AWS. This significantly reduced costs around hosting and management. Their data now resided in Snowflake, which allows them to control costs and performance for each data set using a strong warehouse strategy.

This was the smoothest migration we have ever completed.

We have had upgrades that were harder than this.

About SME Solutions Group, Inc.

SME works with organizations across industries to bring a lasting and modern approach to Business Intelligence (BI). SME's team of certified analysts, architects, admins and trainers holistically approach pain points to find solutions in areas of cloud transformation, data literacy, data governance, software support and assessment. With core values of embracing the importance of data, SME carefully chooses technologies that provide insights and clarity to its clients. With extensive expertise, clients are provided a seamless integration of their BI platforms and newfound capabilities of working with data.