duckdb-web icon indicating copy to clipboard operation
duckdb-web copied to clipboard

Issue found on page 'Attach to a DuckDB/Sqlite Database over HTTPS or S3'

Open leestorm4520 opened this issue 7 months ago • 0 comments

Please describe the problem you encountered in the DuckDB documentation and include the "Page URL" link shown below. Note: only create an issue if you wish to report a problem with the DuckDB documentation. For questions about DuckDB or the use of certain DuckDB features, use GitHub Discussions, Stack Overflow, or Discord.

Page URL: https://duckdb.org/docs/guides/network_cloud_storage/duckdb_over_https_or_s3.html

I have proper credential setup and can query different file formats such as parquet, csv, json, and excel in S3. But I cannot attach .duckdb or .sqlite. select * from 's3:///<file_name>.parquet' - Work create view <view_name> as select * from read_json('s3:///<file_name>.json') - Work

attach 's3:///<file_name>.sqlite3' as (TYPE SQLITE, READ_ONLY) - Does not work (Invalid Error: Unable to open database file) call sqlite_attach('s3:///<file_name>.sqlite3'); - Does not work (Invalid Error: Unable to open database file)

(I have sqlite and httpfs extensions installed and loaded)

leestorm4520 avatar Jul 17 '24 15:07 leestorm4520