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.
On ThoughtSpot Cloud, Embrace supports the following external databases:
How it works
- Create a connection to the external database
- Choose from each table the columns 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, Embrace imports these joins.
- After your connection is complete, it becomes a linked data source in ThoughtSpot, so you can query the external database directly.
- It’s also easy to apply transformations, and filter the data.
Key benefits
- Set up and deploy ThoughtSpot faster by connecting directly to the external database.
- Eliminate the need to move data into ThoughtSpot for analysis.
- Centralize data management and governance in the external database.
- Save significant time and money by avoiding ETL pipelines.
- Connect to multiple external databases.
Limitations
Feature availability in Embrace on ThoughtSpot Cloud
Here are the major features that are not currently available in Embrace:
- Spot IQ: Instant insights, Did you know?, Pinboard insights, Analyze
- Monitor
- Custom calendar
- Materialized views
Function availability in Embrace on ThoughtSpot Cloud
The following matrix compares the specific function support across the different databases of Embrace in ThoughtSpot Cloud. Functions not listed here have full support.
| Function | Snowflake | Amazon Redshift |
Google BigQuery |
Azure Synapse |
Oracle Autonomous Data Warehouse |
|---|---|---|---|---|---|
SOUNDS_LIKE |
✗ | ✗ | ✗ | ✗ | ✗ |
STRING_ MATCH_SCORE |
✗ | ✗ | ✗ | ✗ | ✗ |
EDIT_DISTANCE_WITH_CAP |
✗ | ✗ | ✗ | ✗ | ✗ |
APPROX_SET_CARDINALITY |
✗ | ✗ | ✗ | ✗ | ✗ |
COUNT_NOT_NULL |
✗ | ✗ | ✗ | ✗ | ✗ |
SPELLS_LIKE |
✓ | ✗ | ✗ | ✗ | ✗ |
EDIT_DISTANCE |
✓ | ✗ | ✗ | ✗ | ✗ |
Data type availability in Embrace on ThoughtSpot Cloud
The following matrix captures the specific data type support limitations across the different databases of Embrace. Data types not listed here have full support.
| Data Type |
Snowflake |
Amazon Redshift |
Google BigQuery |
Azure Synapse |
Oracle Autonomous Data Warehouse |
|---|---|---|---|---|---|
BINARY |
✗ | ✓ | ✓ | ✗ | ✗ |
VARBINARY |
✗ | ✓ | ✓ | ✗ | ✗ |
TIMESTAMPTZ |
✓ | ✗ | ✗ | ✗ | ✗ |
GEOMETRY |
✓ | ✗ | ✓ | ✓ | ✗ |
Additional specific exceptions
The following list captures the specific limitations across the different databases of Embrace. Databases not listed here have full support.
- General: all databases
-
- Sample values
- Embrace does not internationalize sample values in tables.
- Delayed UI rendering
- For connections with a very large number of tables (on the order of 1000's of tables), UI rendering may take a very long time. These connections may time out.
- Deleting columns
- After specifying a connection, columns cannot be deleted from the table. Editing a connection makes it possible to add additional columns, but not to remove them.
Next steps
- Add a Snowflake connection
Create the connection between ThoughtSpot and tables in an external Snowflake database. - Add a Redshift connection
Create the connection between ThoughtSpot and tables in an external Amazon RedShift database. - Add a Google BigQuery connection
Create the connection between ThoughtSpot and tables in an external Google BigQuery database. - Add an Azure Synapse connection
Create the connection between ThoughtSpot and tables in an external Azure Synapse database. - Add an Oracle Autonomous Data Warehouse connection
Create the connection between ThoughtSpot and tables in an external Oracle Autonomous Data Warehouse database.