cldellow / datasette-parquet

Add DuckDB, Parquet, CSV and JSON lines support to Datasette
Apache License 2.0
45 stars 5 forks source link

add flag to install and load httpfs #7

Closed cldellow closed 1 year ago

cldellow commented 1 year ago

so, eg, this query will work:

select count(*), count(distinct vendorid)
from read_parquet('https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2022-01.parquet')
limit 1

Currently if you try this query, you'll get:

IO Error: No files found that match the pattern "https://d37ci6vzurychx.cloudfront.net/trip-data/yellow_tripdata_2022-01.parquet"

This should be opt in, though - the ability to make outbound connections is probably a surprising one.