Explains what the feature is or what its benefits are to the user or customer.
The ODBC driver supports a limited set of SQL commands. When developing software that uses the ThoughtSpot ODBC driver, use this reference of supported commands.
This reference is intended for developers using other tools (ETL, etc.) to connect to ThoughtSpot via the ODBC driver.
|CREATE TABLE||Creates a table with the specified column definitions and constraints. The table is replicated on each node.||
CREATE TABLE country_dim (id_number int, country varchar, CONSTRAINT PRIMARY KEY (id_number));
|INSERT||Creates placeholders in the table to receive the data.||
INSERT INTO TABLE country_dim (?, ?);
|DELETE FROM <table>||Deletes ALL rows from the specified table. Does not support the WHERE clause.||
DELETE FROM country_dim;
|SELECT <cols_or_expression> FROM <table_list> [WHERE <predicates>] [GROUP BY <expressions>] [ORDER BY <expressions>]||Fetches the specified set of table data.||
SELECT id_number, country FROM country_dim WHERE id_number > 200;