Source
AWS PrivateLink and Snowflake detailed troubleshooting Guide
Note down the DNS name server from PrivateLink VPCE endpoint configuration.