S3 is not working properly with DuckDBClient

[kimmolinna]

@domoritz The following is working nicely in shell.duckdb.org and with duckdb-client:

SET s3_region='fr-par';
SET s3_endpoint='s3.fr-par.scw.cloud';
SET s3_access_key_id='';
SET s3_secret_access_key='';
SELECT * FROM 's3://file.parquet' LIMIT 5;

but it doesn't return anything in ObservableHQ/DuckdDBClient. SELECT count(*) FROM 's3://file.parquet' works in ObservableHQ thus the credentials must be the correct ones.

[Mause]

Have you tried specifying a bucket name in the s3:// URI?

[kimmolinna]

@domoritz This is weird. DuckDBClient is working nicely with Incognito but when the parquet file is in cache SELECT * is not working but SELECT count(*)works.