The S3 source enables syncing of file-based tables with support for multiple files using glob-like pattern matching, and both Full Refresh and Incremental syncs, using the last_modified property of files to determine incremental batches. You can choose if this connector will read only the new/updated files, or all the matching files, every time a sync is run.

ClickHouse is a fast and scalable database developed by Yandex. ClickHouse is not easy to mainatain, however the performance is remarkable. Managed services can be obtained from Altinity.Cloud