IP Address for Whitelisting

Queries and Resources
1

I am trying to establish a resource connection to Snowflake. We have whitelisted the set of IP addresses you identify on this help center document. However, we are seeing connections initiated from 44.210.125.249.

image

Can you help me confirm the comprehensive set of addresses we should be whitelisting as source addresses from Retool please?

2

Just to add some additional context... these are the IP addresses listed in the help center document. You can see that 44.210.125.249 is not included in that list.

  • 3.77.79.249
  • 3.77.79.250
  • 35.90.103.132
  • 35.90.103.133
  • 35.90.103.134
  • 35.90.103.135
  • 44.208.168.68
  • 44.208.168.69
  • 44.208.168.70
  • 44.208.168.71
3

I am still struggling with this - is there anyone from the Retool team who can confirm this information?

4

Hi @Checkr_Chris,

Thanks for reaching out! I'm looking into this. I haven't found references to that IP address internally. The IP addresses listed in the docs are the only IP addresses you should need :thinking: Is this for your Cloud account?

5

This is a Cloud account, yes.

I'll circle back with our data engineers for some further logging and re-post next week.

6

Hi @Tess, we were able to re-try the OAUTH connection and are continuing to see a 44.210.125.249 IP address as the source. We are 100% confident that this IP address part of the oauth process when trying to establish the trust relationship between Snowflake and REtool.

We're not sure how to continue diagnosing this, so I need to ask ... Is there someone at Retool we can get on a Zoom call with to review our oauth setup and see if there's something funky in the way we set it up?

Screenshot 2024-11-18 at 3.09.07 PM

7

Still struggling with how to move past this. Anyone have any thoughts?

8

Our team is looking into this, but so far, we haven't been able to reproduce any issues with Snowflake + Oauth :thinking: We also haven't been able to track down why this IP address is mentioned.

If you can share more screenshots of how the resource is set up, that could help us try to re-create this. For troubleshooting, I'd be curious if you are able to connect to Snowflake using username & password

I'm not sure if we will be able to fully solve it on the call, but you're welcome to join group office hours so that we can take a closer look