If I have different schema in the same Clickhouse instance, do I need a separate connection?

For different schema in the same instance, we shouldn’t need to change the connection. You can just change your SQL in your models to point to the new schema.