Skip to main content

 

ThoughtSpot

Build the Schema

Overview

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

Feature

Before you can load data into ThoughtSpot, you must build a database schema to receive it. You will do this by writing a SQL script, which creates the objects in your schema.

Your SQL script can use any SQL statements that are supported in ThoughtSpot SQL Command Line (TQL). The TQL syntax is similar to the SQL used in other relational databases, but with some important differences. You'll use DDL (data definition language) to create the schema into which you'll load the data. You'll probably want to put all your DDL statements into a text file, which you'll use as a script for creating the schema.

Uploading the SQL Script Through the Browser

You can upload an existing SQL script directly through the browser in the ThoughtSpot application. You can edit the script or add to it right within the browser, too.

The steps to build a schema through the browser are:
  1. Write a SQL Script to Create the Schema
  2. Import a Schema (Use the SQL Editor)

Using TQL to Create the Schema

You can choose to run your SQL script within the Linux shell on the appliance, instead of uploading it through the browser.

  • Was this article helpful?