Connecting data warehouses to ThoughtSpot is no longer just about enabling analytics—it’s about transforming the way organisations interact with their data.
ThoughtSpot's approach to simplifying data integration brings accessibility and speed to the forefront, empowering teams to move from data silos to actionable insights in record time.
Setting up a data connection in ThoughtSpot is a straightforward process that allows you to integrate your data warehouse and start analysing your data efficiently. Whether you’re working with Snowflake or another data warehouse, this guide will walk you through the steps in a clear and practical way. Let’s get started.
Step 1: Access the Data Workspace
The first step in building connection starts with accessing ThoughtSpot's Data Workspace. This is a central hub for managing data connections, exploring metadata, and organising your integrations.
How to Get There:
- Open ThoughtSpot and look for the menu in the top-right corner.
- From the dropdown, select Data Workspace to enter the section.
- Once inside, click on the Create New button to initiate your connection setup.
Step 2: Select Your Data Warehouse
Now that you’re in the workspace, it’s time to select your data warehouse. ThoughtSpot supports a variety of options, including Amazon Redshift, Google BigQuery, Microsoft Azure Synapse, and more.
ThoughtSpot supports a variety of cloud data warehouses. For this example, we’ll use Snowflake:
- Choose Snowflake from the list of available options.
- Assign a name to your connection and click Continue.
Step 3: Enter Your Credentials
Input your Snowflake credentials to authenticate the connection. Ensure these are accurate to gain access to your databases, schemas, and tables. Once authenticated, ThoughtSpot will display the databases associated with your credentials.
Step 4: Select Tables for Integration
Now it’s time to choose the specific data you want to integrate into ThoughtSpot. You can select one or multiple tables, depending on your needs.
Navigating Your Data:
- Browse through the databases available under your account.
- Select the schema and the specific table(s) you want to connect.
- On the right-hand side of the screen, you’ll see a handy preview window showing:
- Column names
- Data types
- Sample data
This preview is a lifesaver—it gives you a sneak peek at what’s inside before committing.
Additional Features:
- You can either select individual columns or choose to include all columns from a table.
- Need more than one table? Combine them into a single connection for streamlined analysis.
Step 5: Create the Connection
Once your selections are finalised:
- Click Create Connection in the top-right corner.
- Review the notification summarising the selected tables and columns.
- Confirm your choices and ThoughtSpot will establish the connection in a few moments.
Step 6: Explore and Manage Metadata
After the connection is complete, you can start exploring the metadata of your imported tables. This allows you to get a better understanding of your data structure.
What You Can Do:
- Review column names, data types, and measures.
- Add descriptions or update metadata properties if needed.
- Use this information to optimize your data for analysis.
Taking some time to review and organise your metadata will make it easier to work with your data down the line.
Summary: Prepare for Smarter Analytics with ThoughtSpot
This process ensures your data is ready for searching and analysis within ThoughtSpot, setting the stage for faster and smarter decision-making.
By taking the time to ensure metadata accuracy and proper integration, you help every user within your organisation to access the information they need with minimal technical barriers. Whether you're running quick ad-hoc queries or building robust dashboards, ThoughtSpot’s connection to your cloud data warehouse makes exploring and visualising data more accessible than ever.
Need help connecting Data Warehouse to ThoughtSpot?
At 7Dxperts, we specialise in uncovering the full potential of ThoughtSpot and the modern data stack. Our expertise spans across the most advanced data technologies, including:
- Accelerators for ThoughtSpot: Check out our Dbx2Spot and Snow2Spot solutions to fast-track your ThoughtSpot implementation and make Spotter more accurate .
- Geospatial Analytics: Unlock insights with geospatial data using our Map2Spot accelerator, designed for platforms like #Databricks, #Snowflake, #BigQueryand #Redshift.
- Data Readiness Expertise: We will support you through modernisation, augment with your organisation with a view to handover and partner as advisors over a longer period of time.
Whether you’re just getting started with ThoughtSpot or looking to optimise your analytics strategy, 7Dxperts is here to help you achieve your goals faster and more efficiently.
