Limitations

• The catalog is not refreshed automatically. To update the list of table in the catalog, DETACH from the catalog and ATTACH again.
• Reading tables with deletes is not yet supported.

Curl Request Fails

Problem

When trying to attach to an Iceberg REST Catalog endpoint, DuckDB returns the following error:

IO Error: Curl Request to '/v1/oauth/tokens' failed with error: 'URL using bad/illegal format or missing URL' 

Solution

Make sure that you have the latest Iceberg extension installed:

duckdb 

FORCE INSTALL iceberg FROM core_nightly; 

Exit DuckDB and start a new session:

duckdb 

LOAD iceberg; 

HTTP Error 403

Problem

When trying to list the tables in a remote-attached catalog, DuckDB returns the following error:

SHOW ALL TABLES; 

Failed to query https://s3tables.us-east-2.amazonaws.com/iceberg/v1/arn:aws:s3tables:... http error 403 thrown. Message: {"message":"The security token included in the request is invalid."} 

Solution

Use the duckdb_secrets() function to check whether DuckDB loaded the required credentials:

.mode line FROM duckdb_secrets(); 

If you do not see your credentials, set them manually using the following secret:

CREATE SECRET ( TYPE s3, KEY_ID 'AKIAIOSFODNN7EXAMPLE', SECRET 'wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY', REGION 'us-east-1' );