Skip to content

@sqlrooms/duckdb / loadParquet

Function: loadParquet()

loadParquet(tableName, fileName, options?): string

Load data from a Parquet file into a DuckDB table

Parameters

ParameterTypeDescription
tableNamestringName of the table to create
fileNamestringPath to the Parquet file
options?objectOutputType<{ schema: ZodOptional<ZodString>; select: ZodOptional<ZodArray<ZodString, "many">>; where: ZodOptional<ZodString>; view: ZodOptional<ZodBoolean>; temp: ZodOptional<ZodBoolean>; replace: ZodOptional<ZodBoolean>; }, ZodUnknown, "strip">Load options

Returns

string

SQL query string to create the table