Files & tables
Table
read_single_csv_file()
Reference: DuckDB 2.0.0
Arguments & returns
read_single_csv_file(file, named arguments)
Table
| Overload link | file |
Returns |
|---|---|---|
| #01 | ANY |
TABLE |
Named arguments
Pass these after positional arguments, using name := value.
| Argument | Type |
|---|---|
all_varchar := | BOOLEAN |
allow_quoted_nulls := | BOOLEAN |
auto_detect := | BOOLEAN |
auto_type_candidates := | ANY |
buffer_size := | BIGINT |
column_names := | VARCHAR[] |
column_types := | ANY |
columns := | ANY |
comment := | VARCHAR |
compression := | VARCHAR |
date_format := | VARCHAR |
dateformat := | VARCHAR |
decimal_separator := | VARCHAR |
delim := | VARCHAR |
delimiter := | VARCHAR |
dtypes := | ANY |
encoding := | VARCHAR |
escape := | VARCHAR |
files_to_sniff := | BIGINT |
force_not_null := | VARCHAR[] |
header := | BOOLEAN |
ignore_errors := | BOOLEAN |
max_line_size := | BIGINT |
maximum_line_size := | BIGINT |
names := | VARCHAR[] |
new_line := | VARCHAR |
normalize_names := | BOOLEAN |
null := | ANY |
null_padding := | BOOLEAN |
nullstr := | ANY |
parallel := | BOOLEAN |
quote := | VARCHAR |
rejects_limit := | BIGINT |
rejects_line_size_limit := | BIGINT |
rejects_scan := | VARCHAR |
rejects_table := | VARCHAR |
sample_size := | BIGINT |
sep := | VARCHAR |
separator := | VARCHAR |
skip := | BIGINT |
store_rejects := | BOOLEAN |
strict_mode := | BOOLEAN |
thousands := | VARCHAR |
timestamp_format := | VARCHAR |
timestampformat := | VARCHAR |
types := | ANY |