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.