Issue
User would like to connect to the Warehouse on a verify-full connection (not verify-ca) and is unable to authenticate despite a valid certificate
Environment
External data warehouse connection
Cause
To define the connection to the warehouse via the CNAME of the DNS record associated with the friendly name (eg. postgres-warehouse.[tenant].benchling.com) assigned to the warehouse. Please note this pinned hostname is subject to change.
Resolution steps
Retrieve the CNAME of the DNS record and use that for the connection. We recommend using tools like nslookup or dig to find this value.