yes set the ssl off and access using path

Question

Robin Moffatt · Answer

is that an environment variable to set

Barak Amar · Answer

s3 use ssl=false

Barak Amar · Answer

in duckdb

Barak Amar · Answer

set s3 url style= path

Barak Amar · Answer

you may need to set also the region

Robin Moffatt · Answer

```D SET s3 use ssl=false D select count from read parquet <s3 drones03 main Registations P107 Active 2017 parquet> count star int64 5819 ```

Robin Moffatt · Answer

boom

Robin Moffatt · Answer

thanks < Barak Amar>

Robin Moffatt · Answer

out of interest what does setting the region do in the context of the lakeFS S3 gateway

Barak Amar · Answer

mainly used as part of signing the request between S3 client and lakefs

Robin Moffatt · Answer

so can it be set to any valid region

Barak Amar · Answer

and also as part of the S3 client used to communicate with the underlying storage

Barak Amar · Answer

from lakefs to S3 you need to set the region based on your bucket location

Barak Amar · Answer

there is support for multiple regions

Robin Moffatt · Answer

ok thanks

Barak Amar · Answer

the first part I wrote is the part that is relevant to the S3 gateway

Barak Amar · Answer

so it doesn t have any real meaning there just by the protocol