Mapping ThoughtSpot's Falcon Tables Visually

DbSchema gives ThoughtSpot teams a design-first workflow: import the existing schema as an interactive ER diagram, refine it visually, and ship every change as a reviewed SQL script.

Built for visual modeling, schema documentation, and deployment, with an offline model you can keep in Git, team collaboration, and documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See ThoughtSpot Features Download ThoughtSpot JDBC Driver · All drivers

Schema Visualization for ThoughtSpot's Falcon Engine

ThoughtSpot's Falcon in-memory database stores data in a proprietary columnar engine optimized for search-driven analytics. While ThoughtSpot provides a web-based modeling interface for worksheets and tables, data engineers working on ingestion pipelines or schema design sometimes need a SQL-level view of the data model. DbSchema connects to ThoughtSpot via the JDBC driver, discovers the available Falcon tables, and renders them as an entity-relationship diagram for data engineers managing the deployment.

The free Community edition covers the core reverse engineering workflow: discover Falcon tables, lay them out on the diagram, and edit column definitions visually. A 15-day Pro trial in the same installer unlocks the offline design model with Git versioning, the visual query builder, and interactive HTML5 documentation export for teams that need to share the schema beyond the engineering group.

Download DbSchema Free See ThoughtSpot Features

ER Diagrams for ThoughtSpot Falcon Tables

DbSchema reads the ThoughtSpot schema through the JDBC connection and displays Falcon tables, columns, and join relationships on a visual canvas. This structural view complements the ThoughtSpot web modeling interface, providing a developer-oriented schema perspective for engineers maintaining the data layer.

Visual Query Builder for ThoughtSpot Data

DbSchema's query builder generates SQL-compatible queries against ThoughtSpot tables without requiring knowledge of TQL syntax. Select tables, choose columns, and apply filters from a graphical interface to quickly inspect data loaded into the Falcon engine for validation or debugging purposes.

Schema Documentation for ThoughtSpot Data Engineers

DbSchema generates HTML documentation from the ThoughtSpot schema, capturing table structures, column types, and join definitions. This documentation is useful for data engineering teams maintaining large ThoughtSpot deployments where schema changes need to be tracked alongside worksheet and pinboard configurations.

From Download to ThoughtSpot ER Diagram

Here is the full path from installing DbSchema to a diagram of your Falcon tables:

1. Install DbSchema on your machine — no account needed.
2. Download the ThoughtSpot JDBC driver from the ThoughtSpot developer portal and register it via DbSchema's driver manager under Connections > Manage Drivers.
3. Create a connection using driver class com.thoughtspot.jdbc.Driver and the JDBC URL jdbc:thoughtspot://host:12345/, where 12345 is the JDBC port commonly configured for the endpoint.
4. Authenticate with your ThoughtSpot username and password.
5. Connect — DbSchema discovers the Falcon tables and lays out the first diagram.

ThoughtSpot Data Engineers Get These Benefits

• Visualize ThoughtSpot Falcon table schemas and join relationships as ER diagrams
• Run TQL-compatible queries from a desktop client without the ThoughtSpot web interface
• Generate documentation for ThoughtSpot schemas to support data engineering workflows
• Inspect ThoughtSpot table data with the query builder without writing raw SQL
• Compare ThoughtSpot schema versions between development and production deployments

Give the ThoughtSpot data layer a developer-friendly view. Download DbSchema for free and see your Falcon tables as an ER diagram alongside your worksheets.

Related databases

Teams working with ThoughtSpot often use these engines too. Explore dedicated guides and JDBC setup for each.

• Amazon Athena
• Amazon Timestream
• Azure Synapse
• ClickHouse
• Databricks
• Dataverse

Browse all 100+ supported databases