JSON Table

read_json()

Reference: DuckDB 2.0.0

Arguments & returns

3 overloads

read_json(path, named arguments)

Table
Overload link path Returns
#01 VARCHAR TABLE
#02 VARIANT TABLE

Named arguments

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

ArgumentType
allow_empty :=BOOLEAN
array :=BOOLEAN
auto_detect :=BOOLEAN
column_statistics :=ANY
columns :=ANY
compression :=VARCHAR
convert_strings_to_integers :=BOOLEAN
date_format :=VARCHAR
dateformat :=VARCHAR
field_appearance_threshold :=DOUBLE
file_row_number :=BOOLEAN
filename :=ANY
format :=VARCHAR
geojson :=BOOLEAN
hive_partitioning :=BOOLEAN
hive_types :=ANY
hive_types_autocast :=BOOLEAN
ignore_errors :=BOOLEAN
map_inference_threshold :=BIGINT
maximum_depth :=BIGINT
maximum_object_size :=UINTEGER
maximum_sample_files :=BIGINT
records :=ANY
sample_size :=BIGINT
schema :=ANY
timestamp_format :=VARCHAR
timestampformat :=VARCHAR
union_by_name :=BOOLEAN

read_json(paths, named arguments)

Table
Overload link paths Returns
#03 ANY[] TABLE

Named arguments

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

ArgumentType
allow_empty :=BOOLEAN
array :=BOOLEAN
auto_detect :=BOOLEAN
column_statistics :=ANY
columns :=ANY
compression :=VARCHAR
convert_strings_to_integers :=BOOLEAN
date_format :=VARCHAR
dateformat :=VARCHAR
field_appearance_threshold :=DOUBLE
file_row_number :=BOOLEAN
filename :=ANY
format :=VARCHAR
geojson :=BOOLEAN
hive_partitioning :=BOOLEAN
hive_types :=ANY
hive_types_autocast :=BOOLEAN
ignore_errors :=BOOLEAN
map_inference_threshold :=BIGINT
maximum_depth :=BIGINT
maximum_object_size :=UINTEGER
maximum_sample_files :=BIGINT
records :=ANY
sample_size :=BIGINT
schema :=ANY
timestamp_format :=VARCHAR
timestampformat :=VARCHAR
union_by_name :=BOOLEAN

Example

read_json example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Guide example · Run to view results.