Query external tables from your Redshift 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 Redshift environment and connect to Redshift 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 Redshift supports. Refer to the Redshift documentation for more information: Create external table.

Querying your external tables

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

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

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

  3. Create your Redshift 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 an Amazon Redshift connection.

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

Was this page helpful?