Files & tables
Table
read_csv()
Reference: DuckDB 2.0.0
Arguments & returns
3 overloadsread_csv(path, named arguments)
Table
Named arguments
Pass these after positional arguments, using name := value.
| Argument | Type |
|---|---|
all_varchar := | BOOLEAN |
allow_empty := | BOOLEAN |
allow_quoted_nulls := | BOOLEAN |
auto_detect := | BOOLEAN |
auto_type_candidates := | ANY |
buffer_size := | BIGINT |
column_names := | VARCHAR[] |
column_statistics := | ANY |
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 |
file_row_number := | BOOLEAN |
filename := | ANY |
files_to_sniff := | BIGINT |
force_not_null := | VARCHAR[] |
header := | BOOLEAN |
hive_partitioning := | BOOLEAN |
hive_types := | ANY |
hive_types_autocast := | 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 |
schema := | ANY |
sep := | VARCHAR |
separator := | VARCHAR |
skip := | BIGINT |
store_rejects := | BOOLEAN |
strict_mode := | BOOLEAN |
thousands := | VARCHAR |
timestamp_format := | VARCHAR |
timestampformat := | VARCHAR |
types := | ANY |
union_by_name := | BOOLEAN |
read_csv(paths, named arguments)
Table
| Overload link | paths |
Returns |
|---|---|---|
| #03 | ANY[] |
TABLE |
Named arguments
Pass these after positional arguments, using name := value.
| Argument | Type |
|---|---|
all_varchar := | BOOLEAN |
allow_empty := | BOOLEAN |
allow_quoted_nulls := | BOOLEAN |
auto_detect := | BOOLEAN |
auto_type_candidates := | ANY |
buffer_size := | BIGINT |
column_names := | VARCHAR[] |
column_statistics := | ANY |
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 |
file_row_number := | BOOLEAN |
filename := | ANY |
files_to_sniff := | BIGINT |
force_not_null := | VARCHAR[] |
header := | BOOLEAN |
hive_partitioning := | BOOLEAN |
hive_types := | ANY |
hive_types_autocast := | 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 |
schema := | ANY |
sep := | VARCHAR |
separator := | VARCHAR |
skip := | BIGINT |
store_rejects := | BOOLEAN |
strict_mode := | BOOLEAN |
thousands := | VARCHAR |
timestamp_format := | VARCHAR |
timestampformat := | VARCHAR |
types := | ANY |
union_by_name := | BOOLEAN |
Example
Haybarn WASM 2.0.0-rc12 · In your browser
Guide example · Run to view results.