Explains what the feature is or what its benefits are to the user or customer.
For recurring data loads and for scripting loads, use the ThoughtSpot Loader (tsload). This reference section lists all the flags that can be used to modify the behavior of tsload.
General tsload Flags
Table 1. General tsload flags
Specifies the pre-existing target database into which tsload should load the data.
Specifies the target schema.
Default is "falcon_default_schema".
Specifies the tables that you want to load into the database.
The tables must exist in the database specified by --target_database.
Specifies that any data in the target table is to be removed before the new data is loaded.
If supplied, any rows that exist in the table specified by --target_database and --target table will be deleted before this data load. To perform an "upsert" on the existing data, omit this flag or specify --noempty_target.
Specifies the maximum number of rows that can be ignored if they fail to load.
If the number of ignored rows exceeds this limit, the load will be aborted.
Specifies the file to use for storing rows that failed to load.
Input rows that do not conform to the defined schema in ThoughtSpot will be ignored and inserted into this file.
Specifies the format string for date values.
The default format is yearmonthday e.g. "Dec 30th, 2001" and is represented as 20011230. Use the date format specifications supported in the strptime library function.
Specifies the format in which boolean values are represented in the input file.
The default is T_F. You can also use this flag to specify other values. For example, if your data used Y for true and NULL for false, you could specify:
Indicates that the input file contains a header row.
If supplied, the first row of the file is ignored. If not supplied, the first row of the file is loaded as data.
Specifies the escape character used in the input file.
If no value is specified, the default is "(double quotes).
Specifies the enclosing character used in the input file.
If the enclosing character is double quotes, you need to escape it, as in this example: --enclosing_character "\""
--use_bit_boolean_values = [true | false]
Specifies how boolean values are represented in the input file.
If supplied, the input CSV file uses a bit for boolean values, i.e. the false value is represented as 0x0 and true as 0x1. If omitted or set to false, boolean values are assumed to be T_F, unless you specify something else using the flag --boolean_representation [true_false | 1_0 | T_F | Y_N].