Resources

JSON Export

duckdb.org

To export the data from a table to a JSON file, use the COPY statement: COPY tbl TO 'output.json'; The result of queries can also be directly exported to a JSON file: COPY (SELECT * FROM range(3) tbl(n)) TO 'output.json'; {"n":0} {"n":1} {"n":2} The JSON export writes JSON lines by default, standardized as Newline-delimited JSON. The ARRAY option can be used to write a single JSON array object instead. COPY (SELECT…

Visit Site

Resources duckdb.org