Load the data directly from s3 to ClickHouse

[crazylearner]

is there any way to load the data  directly from s3 to clickhouse table?

Note: S3 location will have multiple files to be loaded.

[Denis Zhuravlev]

select *
from s3('http://s3.amazonaws.com/bucketname/test/file.csv',

'accesskey','secretkey','CSV', 'column1 String');

select * from s3('http://host/bucket/*.csv...