ColdFusion not maintaining connection to Azure Data Warehouse
How does ColdFusion Server manage database connections when there are client variables?
With ColdFusion Server version 4.5.1 SP1 and higher, when you store your client variables in a database, your code connects to the database only when a variable is set. This prevents unnecessary database connections, for instance, in a case where you are using client management, but no client variables are present in a particular request.
https://helpx.adobe.com/coldfusion/kb/database-connections-handled-coldfusion.html