JSON Table

read_single_json_file()

Reference: DuckDB 2.0.0

Arguments & returns

read_single_json_file(file, named arguments)

Table
Overload link file Returns
#01 ANY TABLE

Named arguments

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

ArgumentType
array :=BOOLEAN
auto_detect :=BOOLEAN
columns :=ANY
compression :=VARCHAR
convert_strings_to_integers :=BOOLEAN
date_format :=VARCHAR
dateformat :=VARCHAR
field_appearance_threshold :=DOUBLE
format :=VARCHAR
geojson :=BOOLEAN
ignore_errors :=BOOLEAN
map_inference_threshold :=BIGINT
maximum_depth :=BIGINT
maximum_object_size :=UINTEGER
maximum_sample_files :=BIGINT
records :=ANY
sample_size :=BIGINT
timestamp_format :=VARCHAR
timestampformat :=VARCHAR