DuckDB – Nextra

Cheatsheet

scoop install duckdb

JDBC URL

jdbc:duckdb:

JDBC URL

jdbc:duckdb:$database_file_path

SELECT * FROM read_csv_auto('file.csv');

duckdb -s "FROM '$file_parquet' LIMIT 10;"

SELECT * FROM 'file.parquet';

If the file does not end in .parquet, use the read_parquet function:

SELECT * FROM read_parquet('file.parq');

SELECT * FROM 'directory/*.parquet';

SELECT * FROM parquet_metadata('file.parquet');

SELECT * FROM read_parquet(['folder1/*.parquet', 'folder2/*.parquet']);

DESCRIBE SELECT * FROM 'file.parquet';

SELECT * FROM parquet_schema('file.parquet');

SELECT * FROM parquet_file_metadata('file.parquet');

CREATE TABLE table_name AS SELECT * FROM read_csv_auto('file.csv');

CREATE TABLE test AS
    SELECT * FROM 'file.parquet';
COPY test TO 'test.xlsx' WITH (FORMAT xlsx, HEADER true);

SELECT extension_name, installed, description
FROM duckdb_extensions();

.open $database_file_path

Ctrl+D

.quit

.tables