Make sure to add this to /etc/clickhouse-server/config.d/kafka.xml before running migration.
npm install @netronk/clickhouse
``text sasl_ssl SCRAM-SHA-256 ``
text sasl_ssl SCRAM-SHA-256