Resources

CSV Import

duckdb.org

To read data from a CSV file, use the read_csv function in the FROM clause of a query: SELECT * FROM read_csv('input.csv'); Alternatively, you can omit the read_csv function and let DuckDB infer it from the extension: SELECT * FROM 'input.csv'; To create a new table using the result from a query, use CREATE TABLE ... AS SELECT statement: CREATE TABLE new_tbl AS SELECT * FROM read_csv('input.csv'); We can use DuckDB'…

Visit Site