duckdb / duckdb/duckdb-web

Issue found on page 'CSV Auto Detection' - sniff_csv-function arguments

Open
#3,369 0 comments 0 reactions 0 assignees View on GitHub
csv import / export issue found on page
Dominant language
HTML
Stars
301
Forks
597
Avg merge
1d 14h
Merged PRs (30d)
62

Description

In the CSV autodetection page, in the section `sniff_csv` Function it reads:

> The `sniff_csv` function accepts an optional `sample_size` parameter to configure the number of rows sampled.

But going by its entry in `duckdb_functions()`, it appears that the sniffer supports all parameters also supported by read_csv.

I didn't check them all, but I verified that at least ignore_errors works as it does for read_csv.
If other parameters are also used by the sniffer, it would be good to note that, and to have a back reference to https://duckdb.org/docs/data/csv/overview#parameters.

There would also need to be some text to explain the relationship between what is passed and what will be discovered. One would assume the sniffer would use the parameters passed to it as given, and would detect values for those parameters that are not passed, but it would be good to document that explicitly.

Page URL:

Contributor guide

Open the contributing guide

Research direction

Start at the CSV Auto Detection page's `sniff_csv` Function section and compare its documented arguments with the `duckdb_functions()` entry and the CSV overview's parameters reference. Document which parameters are supported, how supplied values relate to detected values, and add the requested back reference.

Written by the indexing model from the issue text.

Assessment

Domain
documentation
Issue type
Documentation
Difficulty
2/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.