Source
SYSTEM$GET_SERVICE_DNS_DOMAIN
This is the same DNS domain that appears in the DNS name (as reported by SHOW SERVICES) for any service in the DATA_SCHEMA schema.
How to configure the AWS DNS service (Route 53) to access Snowflake via a PrivateLink
This is required to help translate the URL lookup to correctly resolve and map to the new PrivateLink URL that is not publicly available.
How to Setup On-Premise DNS to communicate with AWS PrivateLink with Snowflake.
How to Setup On - Premise DNS to communicate with AWS PrivateLink with Snowflake.