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
| ||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 |
| ||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 |
| ||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 string for datetime values.||The default is yearmonthday hour:minute:second e.g. Dec 30th, 2001 1:15:12 and is represented as 20011230 01:15:12. Use the datetime format specifications supported in the strptime library function.|
| ||Specifies the format string for time values.||The default is hour:minute:second. Use the time format specifications supported in the strptime library function.|
| ||Specifies the verbosity of log messages.||Provide a values from 0 to 6, to designate the verbosity level. By default, verbosity is set to the minimum, which is 0.|
| ||Skips fractional seconds when loading data.||If supplied, the upserts logic may be affected, especially if the date time being loaded is a primary key, and the data has millisecond granularity. Load the data twice, once as a string with a primary key, and again with second granularity date time. There is no support to store fractional seconds in the ThoughtSpot system.|
File loading tsload flags
The following flags are used when loading data from an input file:
| ||Specifies the location of the file to be loaded.|
| ||Specifies the data file format.||Optional. The default is csv.|
| || |
Specifies the field delimiter used in the input file.
| ||Specifies that the field separator appears after every field, including the last field per row.||Example row with trailing field separator: a,b,c, |
The default is false.
| ||Specifies how null values are represented in the input file.||These values will be converted to NULL upon loading.|
| ||Specifies whether the “date” or “datetime” values in the input file are represented as epoch values.|
| ||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: |
| ||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