Resources

JSON Import

duckdb.org

To read data from a JSON file, use the read_json_auto function in the FROM clause of a query. SELECT * FROM read_json_auto('input.json'); To create a new table using the result from a query, use CREATE TABLE AS from a SELECT statement. CREATE TABLE new_tbl AS SELECT * FROM read_json_auto('input.json'); To load data into an existing table from a query, use INSERT INTO from a SELECT statement. INSERT INTO tbl SELECT *…

Visit Site

Resources duckdb.org