duckdb / duckdb_aws

MIT License
34 stars 12 forks source link

Cannot install aws extension #39

Closed pdemarti closed 3 weeks ago

pdemarti commented 2 months ago

Not sure what I'm doing wrong here. I'm trying to install the 'aws' extension from a Python notebook. I get an HTTPException: HTTP Error: Failed to download extension "aws" (...).

Issue

import duckdb

con = duckdb.connect()
>>> con.install_extension("aws")
---------------------------------------------------------------------------
HTTPException                             Traceback (most recent call last)
Cell In[1], line 4
      1 import duckdb
      3 con = duckdb.connect()
----> 4 con.install_extension("aws")

HTTPException: HTTP Error: Failed to download extension "aws" at URL "http://extensions.duckdb.org/v0.8.1/linux_amd64/aws.duckdb_extension.gz"

Candidate extensions: "s3", "fts", "json", "sqlite", "parquet"

Context

>>> con.sql('pragma version')
┌─────────────────┬───────────┐
│ library_version │ source_id │
│     varchar     │  varchar  │
├─────────────────┼───────────┤
│ 0.8.1           │ 325a48c   │
└─────────────────┴───────────┘

# note that spatial can be installed without problem
con.install_extension("spatial")
con.load_extension("spatial")

# at this point, the extensions are:
>>> con.sql('from duckdb_extensions()').df().iloc[:, :4]
      extension_name  loaded  installed                                       install_path
0       autocomplete   False      False                                                   
1                fts    True       True                                         (BUILT-IN)
2             httpfs   False       True  /data/delta/.duckdb/extensions/v0.8.1/linux_am...
3                icu    True       True                                         (BUILT-IN)
4               inet   False      False                                                   
5           jemalloc    True       True                                         (BUILT-IN)
6               json    True       True                                         (BUILT-IN)
7         motherduck   False      False                                                   
8            parquet    True       True                                         (BUILT-IN)
9   postgres_scanner   False      False                                                   
10           spatial    True       True  /data/delta/.duckdb/extensions/v0.8.1/linux_am...
11    sqlite_scanner   False      False                                                   
12             tpcds    True       True                                         (BUILT-IN)
13              tpch    True       True                                         (BUILT-IN)

I also tried in a shell:

curl -LO https://extensions.duckdb.org/v0.8.1/linux_amd64/aws.duckdb_extension.gz

but the file indicates an Access Denied:

<?xml version="1.0" encoding="UTF-8"?>
<Error><Code>AccessDenied</Code>
<Message>Access Denied</Message>
<RequestId>MGKF05K42JKS21X7</RequestId>
<HostId>...(redacted)VT0=</HostId>
</Error>
osalloum commented 3 weeks ago

aws extension become available since duckdb 0.9

https://duckdb.org/docs/archive/0.9/extensions/aws

samansmink commented 3 weeks ago

Yea please consider updating your DuckDB, we have a shiny new v1.0.0 out :)