load_file_preview
Preview a data file's first rows and detected settings—encoding, delimiter, header, null markers, and suggested SingleStore types—to plan table creation without writing data.
Instructions
Read the start of a data file on this computer for the Load file wizard (nothing is written).
Detects (or takes) the encoding, delimiter, quote ("" = none), header, null markers and decimal comma; returns the
first rows, the columns with suggested SingleStore types and date / time formats (``formats``: {column: format
name} overrides), the estimated row count, whether the file is over the size limit, and for ``database`` a CREATE
TABLE for ``table`` (default: from the file name) plus ``target`` (does the table exist; its column mapping).Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| quote | No | " | |
| table | No | ||
| header | No | ||
| formats | No | ||
| database | No | ||
| encoding | No | ||
| delimiter | No | ||
| null_markers | No | ||
| decimal_comma | No |