Figured out - the signoz clickhouse container didn't have ownership to make changes. Running the script with

sudo

resolves it.