...
Max connections on data warehouse = 300 connections
Possible:
Connections were not closed when done with them?
Maybe the issue is in the Oracle OCI layer?
Cause:
This code was run from someone’s local machine, causing many connections to the data warehouse to be established:
...
Use a context manager for connection pools in python
Set max size of connection pool
Connection pools behave erratically with failovers
Maybe we should increase the amount of connections that are allowed in the Data Warehouse