Explains what the feature is or what its benefits are to the user or customer.
You can view and edit the DDL script that gets generated by ThoughtSpot Data Connect. This allows you to review the table that will be created and make changes to the SQL that generates it.
- Edit the DDL script to point to an existing table in ThoughtSpot. The columns and their order must exactly match that of the existing table. You can check the columns and their order by issuing the
SCRIPT TABLE <table_name>command from TQL. You may need to rearranged the order of columns in the generated DDL so that it matches the order of the target table. In fact, you can even copy the output of the SCRIPT TABLE command and paste it into the DDL editing window.
- Create the table(s) in a different schema than what the default DDL suggests.
- Add sharding using the
PARTITION BY HASH (<number>) <column>syntax.