Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ATTACH remote database doesn't work anymore #1868

Closed
tobilg opened this issue Sep 26, 2024 · 2 comments
Closed

ATTACH remote database doesn't work anymore #1868

tobilg opened this issue Sep 26, 2024 · 2 comments

Comments

@tobilg
Copy link

tobilg commented Sep 26, 2024

What happens?

Is it possible that attaching databases no longer work in in the latest dev versions? When running ATTACH 'https://raw.githubusercontent.com/tobilg/aws-iam-data/main/data/db/iam.duckdb' as aws_iam (READ_ONLY);, I see the following error:

Error: IO Error: Extension https://extensions.duckdb.org/v1.1.0/wasm_eh/httpfs.duckdb_extension.wasm is not available. 

Accessing other files via http seems to work though. When trying to access https://extensions.duckdb.org/v1.1.0/wasm_eh/httpfs.duckdb_extension.wasm I see a 403 error

v258 which is v1.0.0 works with ATTACH statements. I tried a lot of newer versions, without success...

To Reproduce

Try this in the Shell:

https://shell.duckdb.org/#queries=v0,ATTACH-'https%3A%2F%2Fraw.githubusercontent.com%2Ftobilg%2Faws%20iam%20data%2Fmain%2Fdata%2Fdb%2Fiam.duckdb'-as-aws_iam-(READ_ONLY)~,load-httpfs~

Browser/Environment:

Chrome latest

Device:

MacBookPro

DuckDB-Wasm Version:

1.28.1-dev287.0

DuckDB-Wasm Deployment:

shell.duckdb.org

Full Name:

Tobi M.

Affiliation:

None

@carlopi
Copy link
Collaborator

carlopi commented Sep 27, 2024

I think this is now working, can you possibly give it a try?

(fix was making sure httpfs extensions was build and deployed in the right spot)

@tobilg tobilg closed this as completed Sep 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants