⌘+k ctrl+k
1.2.1 (stable)
Search Shortcut cmd + k | ctrl + k
Troubleshooting

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 '⟨YOUR_ACCESS_KEY_ID⟩',
    SECRET '⟨YOUR_SECRET_ACCESS_KEY⟩',
    REGION '⟨YOUR_DEFAULT_REGION⟩'
);