Snowflake connection in Integration Service fails with 504 Gateway Timeout error

When attempting to establish a connection with Snowflake, after clicking the 'Connect' button, the spinner continuously spins. Upon inspecting the Network logs, a 504 Gateway Timeout error is observed.

To resolve this issue, follow these steps:

  • Check with the IT team that all the IPs in our documentation were whitelisted.
  • Verify that the Snowflake hostname is correct and constructed as shown in the Snowflake authentication page
    • Note: "AWS Privatelink" is not supported in UiPath. If the hostname has "privatelink" in it, the connection will fail.
  • Verify that the Snowflake user being used to authenticate has a "Default Role" assigned. Also, the Default Role must have minimum "USAGE" privileges.