read_csv()

Reference: DuckDB 2.0.0

Arguments & returns

3 overloads

read_csv(path, named arguments)

Table
Overload link path Returns
#01 VARCHAR TABLE
#02 VARIANT TABLE

Named arguments

Pass these after positional arguments, using name := value.

ArgumentType
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.

ArgumentType
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

read_csv example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Guide example · Run to view results.