@sqlrooms/duckdb / load

Function: load()

load(method, tableName, fileName, options?, defaults?): string

Generic function to load data from a file into a DuckDB table

Parameters

Parameter	Type	Description
method	"read_json" | "read_ndjson" | "read_parquet" | "read_csv" | "auto" | "st_read"	The DuckDB read method to use (e.g., 'read_csv', 'read_json')
tableName	string	Name of the table to create
fileName	string	Path to the input file
options?	{ [key: string]: unknown; schema: string; select: string[]; where: string; view: boolean; temp: boolean; replace: boolean; }	Load options including select, where, view, temp, replace and file-specific options
options.schema?	string	-
options.select?	string[]	-
options.where?	string	-
options.view?	boolean	-
options.temp?	boolean	-
options.replace?	boolean	-
defaults?	Record<string, unknown>	Default options to merge with provided options

Returns

string

SQL query string to create the table