DuckDB function sniff_csv().
Usage
sniff_csv(
col0,
force_match,
hive_types,
union_by_name,
hive_partitioning,
filename,
thousands,
strict_mode,
hive_types_autocast,
encoding,
dtypes,
column_types,
auto_detect,
sample_size,
files_to_sniff,
dateformat,
columns,
all_varchar,
new_line,
header,
types,
skip,
compression,
comment,
quote,
max_line_size,
store_rejects,
delim,
sep,
column_names,
buffer_size,
timestampformat,
normalize_names,
ignore_errors,
names,
allow_quoted_nulls,
maximum_line_size,
rejects_table,
force_not_null,
parallel,
auto_type_candidates,
rejects_scan,
rejects_limit,
nullstr,
escape,
decimal_separator,
null_padding
)Arguments
- col0
VARCHAR- force_match
BOOLEAN- hive_types
ANY- union_by_name
BOOLEAN- hive_partitioning
BOOLEAN- filename
ANY- thousands
VARCHAR- strict_mode
BOOLEAN- hive_types_autocast
BOOLEAN- encoding
VARCHAR- dtypes
ANY- column_types
ANY- auto_detect
BOOLEAN- sample_size
BIGINT- files_to_sniff
BIGINT- dateformat
VARCHAR- columns
ANY- all_varchar
BOOLEAN- new_line
VARCHAR- header
BOOLEAN- types
ANY- skip
BIGINT- compression
VARCHAR- comment
VARCHAR- quote
VARCHAR- max_line_size
VARCHAR- store_rejects
BOOLEAN- delim
VARCHAR- sep
VARCHAR- column_names
VARCHAR[]- buffer_size
UBIGINT- timestampformat
VARCHAR- normalize_names
BOOLEAN- ignore_errors
BOOLEAN- names
VARCHAR[]- allow_quoted_nulls
BOOLEAN- maximum_line_size
VARCHAR- rejects_table
VARCHAR- force_not_null
VARCHAR[]- parallel
BOOLEAN- auto_type_candidates
ANY- rejects_scan
VARCHAR- rejects_limit
BIGINT- nullstr
ANY- escape
VARCHAR- decimal_separator
VARCHAR- null_padding
BOOLEAN