ClickHouse / ClickHouse

ClickHouse® is a real-time analytics DBMS
https://clickhouse.com
Apache License 2.0
37.27k stars 6.87k forks source link

Please add ability to specify region in S3 and GCS table function. #52301

Open minguyen9988 opened 1 year ago

minguyen9988 commented 1 year ago

https://github.com/ClickHouse/ClickHouse/blob/32b765a4ba577acbfdb09a8d400dad8d4ef0f48d/src/TableFunctions/TableFunctionS3.cpp#L338C1-L348C3

We have a need to choose region in GCS bucket, default us-east-1 for AWS doesnt work.

In a bigger picture, can you expose all settable parameter from the underlying aws-sdk-cpp , it can be expose through a dynamic map parameter similar to headers. If the higher level API obfuscate too much of the underlying API, it will lose the flexibility of the underlying API. If there is no security issue, higher level API should expose a method to give the full range of the underlying API.

arnaudbriche commented 6 days ago

Any chance this will be implemented ?