If your company stores source data externally in data warehouses, you can use ThoughtSpot Embrace to directly query that data and use ThoughtSpot’s analysis and visualization features, without moving the data into ThoughtSpot. If you decide later you want to copy your data into ThoughtSpot, you can also do that with Embrace.
How it works
You create a connection to a Snowflake database, choosing the columns from each table that you want to explore in your live query. Primary key and foreign key relationships are imported along with the primary and foreign key tables. If there are any joins in the tables of your connection, they are also imported. After your connection is complete, it becomes a linked data source in ThoughtSpot that allows you to query the Snowflake database directly. It’s easy to apply transformations and filter the data also.
Key benefits
- Set up and deploy ThoughtSpot faster by connecting directly to a Snowflake database.
- Eliminate the need to move data into ThoughtSpot for analysis.
- Centralize data management and governance in Snowflake.
- Save significant time and money by avoiding ETL pipelines.
- Set up and schedule sync of data into ThoughtSpot.
- Connect to multiple Snowflake databases (starting in release 5.3.1).
Embrace modes
Embrace has two operating modes:
- Linked: ThoughtSpot queries your data in the external Snowflake database.
- Synced: ThoughtSpot queries a copy of your data stored in ThoughtSpot.
When you create your connection to a Snowflake database, by default, it is a Linked connection. If you want to copy the external data into ThoughtSpot, you must sync the data. The features available with Linked and Synced tables are slightly different.
Features in Embrace modes
| Feature | Linked Tables | Synced Tables |
|---|---|---|
| Simple Search | Yes | Yes |
| Complex searches like Versus, Inline Subquerying, Growth | Yes | Yes |
| Search Suggestions for column names | Yes | Yes |
| Search Suggestions for column values | No | Yes |
| Headlines at the bottom that summarize tables | Yes | Yes |
| All Chart Types & Configurations | Yes | Yes |
| SpotIQ Instant Insights | No | Yes |
| SpotIQ pre-computed insights | No | Yes |
| Table and Column Remapping | No | N/A |
| Custom Calendar | No | Yes |
| Materialized Views | No | Yes |
Next steps
- Add a connection
Create the connection between ThoughtSpot and tables in a Snowflake database. - Sync Set your connection to copy tables from Snowflake into ThoughtSpot.
- Modify a connection
Edit, remap or delete a connection to tables in a Snowflake database. - Connectors reference
Source cloud data connectors, and their connection credentials, supported by Embrace.