Files over HTTPS, S3 and GCS
DuckDB reads remote files directly; Parquet is read selectively (only the columns and row groups a query needs).
CREATE TABLE trips AS FROM read_parquet('https://example.com/data/trips.parquet');CREATE TABLE sales AS FROM read_parquet('s3://my-bucket/sales/*.parquet'); -- httpfs + credentials- Native (CLI, servers): the
httpfsextension handleshttps://,s3://andgs://. Give S3 credentials with a DuckDBCREATE SECRETin a setup statement, or let the server’s environment provide them. - In the browser: HTTPS works when the file’s server sends CORS headers (
Access-Control-Allow-Origin). Object storage needs a CORS rule for the site’s origin. - Read once, use often: a remote file read by several panels is downloaded again by each one in the browser. Read it into a table once —
CREATE TEMP TABLE … AS FROM read_parquet(…)— rather than a view;dashboard --checkflags the view (design/remote-view).