Unfortunately there are several pull requests to bring into flyway support of Clickhouse, but most of them stalled, unfortunately.
This repository contains attempt to build it with latest PR#3611.
Please find images in https://hub.docker.com/r/hubbitus/flyway-clickhouse
Said you placed your migrations in directory clickhouse/migrations, and config file in conf/flyway.conf then you may run it like:
podman run --rm -it --name flyway \
-v ./clickhouse/migrations:/flyway/sql:z
-v ./conf:/flyway/conf:ro,z \
--network=host \
docker.io/hubbitus/flyway-clickhouse:master \
-user=default -password='' -url=jdbc:clickhouse://default@127.0.0.1:8123/datamart migrateOff course, you may omit name, network mode or run it in Kubernetes, as you wish.