Query external tables from your Snowflake connection

ThoughtSpot supports querying external tables stored in external data stores, such as Amazon S3 or Google Cloud Storage, via your cloud data warehouse. These external tables can be in formats such as text, parquet, avro, or json, depending on the formats your cloud data warehouse supports.

After you create the external tables in your Snowflake environment and connect to Snowflake in ThoughtSpot, you can query them like any other table in your connection. You can also join them to other tables in the connection, as long as they belong to the same connection. External tables in ThoughtSpot behave in the same way that regular tables from your connection do. However, note that there may be performance implications when querying the external tables, since you do not store them in the cloud data warehouse.

This option is available for Amazon Redshift, Google BigQuery, and Snowflake.

Supported data stores and file formats

ThoughtSpot supports any data stores or file formats that Snowflake supports. Refer to the Snowflake documentation for more information: Introduction to External Tables.

Querying your external tables

To query your external tables in ThoughtSpot, follow these steps:

  1. Ensure that Snowflake supports your data store(s) and file format(s). Refer to Supported data stores and file formats.

  2. Create the external table(s) in Snowflake. For assistance, refer to the Snowflake documentation.

  3. Create your Snowflake connection, if you have not already done so. When selecting tables, select the external tables you want to query, as well as any other tables. Refer to Add a Snowflake connection.

    Ensure that your external tables are in the same database and schema as the database and schema specified in your Snowflake connection.
  4. Search the data from your external table.