Sigma does not charge for connections. You can have as many as you require, of any of the available types. It is common for Sigma customers to have different connections for different use-cases.
In addition, customers can use a single connection and switch the warehouse and role being used by a user or team. This saves administrative time and complexity and pushes data access policies to the lowest level: the warehouse. It’s also a very powerful feature for embedded use cases.