Skip to main content

 

ThoughtSpot

Import a Schema (Use the SQL Editor)

Overview

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

Feature

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.
    File:02_Administration/Administrator_Guide_3.1/030/040/060/data_icon.png

    The Data icon

  3. Click Actions and select Import Schema.
    File:02_Administration/Administrator_Guide_3.1/030/040/060/import_schema.png

    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.
    File:02_Administration/Administrator_Guide_3.1/030/040/060/SQL_editor.png

    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?