I am trying to run a TRUNCATE command on my exasol DWH from Databricks using the pyexasol. This works perfectly fine when I have the cluster access mode as "No Isolation Shared" which does not have access to our Unity Catalog. When I change the cluster access mode to "Shared" and now has access to Unity Catalog, the cluster fails to connect to Exasol DWH with the following error message:
"Could not connect to Exasol: [Errno 111] Connection refused"
Any ideas how to solve this?