Skip to content

DuckDB instructions don't work for R2 Data Catalog #25257

@jschlesser

Description

@jschlesser

I walked through the R2 Data Catalog getting started. It successfully created a table. After that I tried to connect DuckDB to the catalog and using your instructions here https://developers.cloudflare.com/r2/data-catalog/config-examples/duckdb/

when I tried to execute the ATTACH command it complains
Invalid Error:
'https' scheme is not supported.

The endpoint I'm using is the https://catalog.cloudflarestorage.com/8df00650d0c31c5eeeffd31226eec304/r2-data-catalog-tutorial from my R2 Data Catalog dashboard Catalog URI setting. I'm assuming that is correct even through the words ENDPOINT and Catalog URI aren't the same, but its the only URI in the dashboard.

The whole command
ATTACH '8df00650d0c31c5eeeffd31226eec304_r2-data-catalog-tutorial' AS my_r2_catalog ( TYPE ICEBERG, ENDPOINT 'https://catalog.cloudflarestorage.com/8df00650d0c31c5eeeffd31226eec304/r2-data-catalog-tutorial');

when I try to replace the https with s3 it complains
Invalid Configuration Error:
Request to 's3://catalog.cloudflarestorage.com/8df00650d0c31c5eeeffd31226eec304/r2-data-catalog-tutorial/v1/config?warehouse=8df00650d0c31c5eeeffd31226eec304_r2-data-catalog-tutorial' returned a non-200 status code (BadRequest_400), with reason: Bad Request

It seems like its looking for something that isn't there.

The duckdb version im using is v1.4.0, I just installed it.

Metadata

Metadata

Labels

product:r2R2 object storage: https://developers.cloudflare.com/r2

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions