The Dremio Blog

Open Data Architecture
Ask Any Question of Your Open Lakehouse with Dremio and ThoughtSpot
Brett Roberts Brett RobertsPrincipal Solutions Architect, Dremio

The adoption and proliferation of BI tools are growing exponentially as more organizations strive to democratize their data. According to EnterpriseAppsToday,  67% of employees will have access to a BI tool by the end of 2022. As more employees utilize BI tools to derive insights, technologies such as Natural Language Processing (NLP), and search have become critical in lowering the barriers to adopting these BI tools. 

ThoughtSpot’s powerful and intuitive Live Analytics platform empowers business users to create personalized, actionable insights from all of their cloud data. By leveraging search and AI, ThoughtSpot instantly analyzes billions of rows of data and returns insights which can then be curated, visualized, and shared in the form of Liveboards. This simplicity allows non-technical data consumers to focus on what’s important: making impactful, data-driven decisions in the moment.  

I am  excited to announce that ThoughtSpot now natively connects to Dremio’s open lakehouse platform! ThoughtSpot customers can now easily create a connection to Dremio through the ThoughtSpot UI in seconds. This makes it remarkably easy to create BI dashboards and explore their data lakes with search functionality.

With Dremio and ThoughtSpot, customers can use ThoughtSpot’s search technology to easily ask questions and leverage Dremio’s robust query technology to return answers immediately. They can create interactive dashboards on their data lakehouse faster than ever with seamless, out-of-the-box connectivity. With Dremio’s no-copy architecture, users can do all that without having to load the data into ThoughtSpot.

Why Dremio for ThoughtSpot

Search at scale: ThoughtSpot supports the ability to perform complex questioning of massive datasets and uses SpotIQ to automate insights and discover key outlines, trends, and more.  Dremio enables customers to execute high-performance queries directly on the data lake on as many as billions of records and get the results in seconds or less. This provides ThoughtSpot users with reduced time to insight to make faster and better decisions. 

Search ALL of your data: Dremio provides the ability to query data from a variety of sources, including Amazon S3, ADLS, GCS, on-premises data lakes, and other databases. Additionally, Dremio users can join data from multiple sources into one consistent view. This lets ThoughtSpot users ask questions and receive answers from ALL of their data,  improving visibility, consistency, and accuracy.

Self-service capability: Using Dremio’s semantic layer, ThoughtSpot users can easily interact with data directly on the data lake. Users can find specific datasets and then easily connect to ThoughtSpot. This significantly decreases the time required for data consumers to gain access to the data. 

How to Get Started

Users can connect both their ThoughtSpot Cloud or software instances to Dremio Cloud and Dremio Software through ThoughtSpot’s Data Connection window. 

Step 1: Navigate to your ThoughtSpot UI and click on Data > Connections from the top navigation pane.

Step 2: Click Add Connection on the top right.

Step 3: Name your connection, click the Dremio icon, and press Continue.

Step 4: ThoughtSpot offers two ways to connect to Dremio: Service Account or OAuth. For Dremio Cloud, you can use a Personal Access Token (PAT) and the Service Account option or you can use OAuth. For Dremio Software, use the Service Account option. 

For OAuth, ThoughtSpot uses Okta. Please refer to Dremio Documentation for how to configure Okta with Dremio.

Dremio Cloud Examples

Dremio Software Example

Step 5: Once you have established the connection between ThoughtSpot and Dremio, you can select tables from Dremio. Note that ThoughtSpot is not loading the tables into memory, but is creating a persistent connection to those tables for you to easily access in the future. 

Now that you have connected Dremio to ThoughtSpot you can begin to quickly and easily build interactive dashboards and start asking questions of your data.  

Here is an example of a dashboard built using a dataset containing over a billion records:

Now that you’ve seen how easy it is to connect ThoughtSpot to Dremio, try it out for yourself! 

Sign up and try Dremio Cloud for FREE on AWS. If you’re not a current ThoughtSpot user, you can try ThoughtSpot Cloud free for 14 days.  Sign up for both and see how quickly you’ll be analyzing your data!

ThoughtSpot Beyond 2022 is right around the corner and Dremio will be there! Stop by the Dremio booth (we’ll be at booth #14) to see for yourself how Dremio and ThoughtSpot can supercharge your business intelligence performance and insights!

Get Started Free

No time limit - totally free - just the way you like it.

Sign Up Now

Watch Demo

Not ready to get started today? See the platform in action.

Check Out Demo