search

exasol / cloud-storage-extension

Exasol Cloud Storage Extension for accessing formatted data Avro, Orc and Parquet, on public cloud storage systems
MIT License
7 stars 11 forks source link

Support for presigned URLs #259

Closed allipatev closed 1 week ago

allipatev commented 1 year ago

By default, all Amazon S3 objects are private, only the object owner has permission to access them. However, the object owner may share objects with others by creating a presigned URL (docs).

Currently Cloud Storage Extension doesn't support presigned URLs and requires a connection object with credentials.

Please consider implementing support for presigned URLs.

ShadyD45 commented 1 year ago

Hi @morazow @allipatev I'm trying to use the export that is mentioned here https://docs.exasol.com/db/latest/sql/export.htm with minio. Does this support it? And can we use the presigned url here Or a connection object? Thanks for help

allipatev commented 1 year ago

Hi @ShadyD45.

Presigned AWS URLs are supported only for IMPORT command (see CHANGELOG: IMPORT allows accessing public files and presigned URLs from Amazon S3). IMPORT from presigned URLs for S3-compatible services could work, but this setup is not being actively tested.

The rest could be discussed in a Support ticket 😉

redcatbear commented 1 week ago

Closing this ticket, since this feature is not on the roadmap.