Skip to main content



Import a Schema (Use the SQL Editor)


Explains what the feature is or what its benefits are to the user or customer.


You can run a SQL script to create your database schema through the browser, without having to log in to the shell on the ThoughtSpot Analytic Search Appliance. You can edit the script and run it directly in the browser to create the schema.

Importing a schema through the Web browser makes it possible to run your SQL script without needing to have a Linux login on the appliance. You can use this capabilities in any of these ways:
  • Create the SQL script ahead of time, and use the browser to run it.
  • Create a blank SQL script, with one dummy line of text, import it, and then use the editor to type your SQL directly into the browser.
  • Use the browser SQL interface as an interactive SQL editor, for example to test an existing script or make changes to an existing schema.
  1. Log In to ThoughtSpot From a Browser.
  2. Click on the Data icon, on the left navigation bar.

    The Data icon

  3. Click Actions and select Import Schema.

    Import Schema

  4. Drag and drop your SQL file into the browser, or choose Browse Your Files to locate it.
  5. You're now in the SQL editor. Use it to view your script and make any changes.

    Import Schema

  6. When ready, run your script by clicking the Execute button.
  7. If there are any errors, correct them and run the script again.
  • Was this article helpful?