DuckDB natively supports multiple S3 compatible object storage providers, like Cloudflare, Google storage and so on. It's documented here:
You can also already use the SET syntax inside Motherduck to query these non AWS providers, but this doesn't persist between sessions, and
md_create_secret()
seems designed specifically to store this kind of information securely and durably.
Can we have support for this in MotherDuck by setting a SECRET for the endpoint too?
Adding this to would likely involve adding one more
s3_endpoint
parameter to the motherduck function
md_create_secret()
, and would be SO helpful for querying data in existing S3 compatible buckets that are not on AWS.