Explains what the feature is or what its benefits are to the user or customer.
Having examined the structure of the data to be loaded and become familiar with the ThoughtSpot SQL Command Line (TQL), you are now ready to create the schema.
To create the schema directly in TQL:
- Connect to the database with the ThoughtSpot SQL Command Line (TQL).
If the database you will be using does not exist, create it now:
TQL> CREATE DATABASE my_database;
Connect to the database:
TQL> USE my_database;
If you wish to use a schema other than the default one,
create it now:
TQL> CREATE SCHEMA my_schema;
Issue a CREATE TABLE command for each table you will create, using the
information in Plan the schema.
Note: Foreign key declaration within a CREATE TABLE will show the table created even if there are problems with the foreign key. Therefore, it is good practice to also issue a separate ALTER TABLE ADD CONSTRAINT FOREIGN KEY command.