Files & tables
Table
sniff_csv()
Arguments & returns
sniff_csv(col0, named arguments)
Table
| Overload link | col0 |
Returns |
|---|---|---|
| #01 | VARCHAR |
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 := | UBIGINT |
column_names := | VARCHAR[] |
column_types := | ANY |
columns := | ANY |
comment := | VARCHAR |
compression := | VARCHAR |
dateformat := | VARCHAR |
decimal_separator := | VARCHAR |
delim := | VARCHAR |
dtypes := | ANY |
encoding := | VARCHAR |
escape := | VARCHAR |
filename := | ANY |
files_to_sniff := | BIGINT |
force_match := | BOOLEAN |
force_not_null := | VARCHAR[] |
header := | BOOLEAN |
hive_partitioning := | BOOLEAN |
hive_types := | ANY |
hive_types_autocast := | BOOLEAN |
ignore_errors := | BOOLEAN |
max_line_size := | VARCHAR |
maximum_line_size := | VARCHAR |
names := | VARCHAR[] |
new_line := | VARCHAR |
normalize_names := | BOOLEAN |
null_padding := | BOOLEAN |
nullstr := | ANY |
parallel := | BOOLEAN |
quote := | VARCHAR |
rejects_limit := | BIGINT |
rejects_scan := | VARCHAR |
rejects_table := | VARCHAR |
sample_size := | BIGINT |
sep := | VARCHAR |
skip := | BIGINT |
store_rejects := | BOOLEAN |
strict_mode := | BOOLEAN |
thousands := | VARCHAR |
timestampformat := | VARCHAR |
types := | ANY |
union_by_name := | BOOLEAN |