Skip to contents

DuckDB function read_csv_auto().

Usage

read_csv_auto(
  col0,
  thousands,
  strict_mode,
  dtypes,
  column_types,
  null_padding,
  column_names,
  buffer_size,
  parallel,
  force_not_null,
  hive_types,
  new_line,
  files_to_sniff,
  dateformat,
  delim,
  sep,
  decimal_separator,
  nullstr,
  escape,
  compression,
  encoding,
  hive_types_autocast,
  all_varchar,
  columns,
  hive_partitioning,
  auto_detect,
  comment,
  quote,
  max_line_size,
  store_rejects,
  union_by_name,
  header,
  types,
  skip,
  filename,
  sample_size,
  timestampformat,
  normalize_names,
  ignore_errors,
  names,
  allow_quoted_nulls,
  maximum_line_size,
  rejects_table,
  auto_type_candidates,
  rejects_scan,
  rejects_limit
)

Arguments

col0

VARCHAR | VARCHAR[]

thousands

VARCHAR

strict_mode

BOOLEAN

dtypes

ANY

column_types

ANY

null_padding

BOOLEAN

column_names

VARCHAR[]

buffer_size

UBIGINT

parallel

BOOLEAN

force_not_null

VARCHAR[]

hive_types

ANY

new_line

VARCHAR

files_to_sniff

BIGINT

dateformat

VARCHAR

delim

VARCHAR

sep

VARCHAR

decimal_separator

VARCHAR

nullstr

ANY

escape

VARCHAR

compression

VARCHAR

encoding

VARCHAR

hive_types_autocast

BOOLEAN

all_varchar

BOOLEAN

columns

ANY

hive_partitioning

BOOLEAN

auto_detect

BOOLEAN

comment

VARCHAR

quote

VARCHAR

max_line_size

VARCHAR

store_rejects

BOOLEAN

union_by_name

BOOLEAN

header

BOOLEAN

types

ANY

skip

BIGINT

filename

ANY

sample_size

BIGINT

timestampformat

VARCHAR

normalize_names

BOOLEAN

ignore_errors

BOOLEAN

names

VARCHAR[]

allow_quoted_nulls

BOOLEAN

maximum_line_size

VARCHAR

rejects_table

VARCHAR

auto_type_candidates

ANY

rejects_scan

VARCHAR

rejects_limit

BIGINT

Value

Unspecified.