Skip to main content

Error: NameResolutionError: Failed to resolve 'hostname'

Genevieve LaLonde
Updated

Error Message:

When trying to run a query against the RelationalAI model you may receive a NameResolutionError message like the below, stating it cannot resolve a hostname.

Screenshot 2025-01-02 at 1.49.35 PM.png

Another example:

HTTPSConnectionPool(...) 
(Caused by NameResolutionError("<urllib3.connection.HTTPSConnection object at 0xffff5dc52c70>: 
Failed to resolve 'sfc-ds1-customer-stage.s3.us-west-2.amazonaws.com' 
([Errno -3] Temporary failure in name resolution)"))

 

Resolution

Enable the S3_RAI_INTERNAL_BUCKET_EGRESS_INTEGRATION with the instructions below.

  1. Edit the notebook settings.
    • Located under the dropdown next to the Start / Active button.
    • settings.png
  2. Go to the External Access tab.
  3. Enable the S3_RAI_INTERNAL_BUCKET_EGRESS_INTEGRATION
    • enable_integration.png
  4. The notebook will automatically restart.
  5. Run the notebook again, starting with the cells at the top of the notebook.

 

Explanation

When running a Snowflake notebook in a warehouse, it is necessary to enable the S3_RAI_INTERNAL_BUCKET_EGRESS_INTEGRATION in order for the notebook to communicate with an S3 bucket. Without this integration, resolving the hostname will fail with this error.

 

Related to

Related articles