I’m running Dremio-Cloud in the EU control plane. I want to connect to a database that has a strict inbound client IP firewall. What IP addresses does Dremio-Cloud use to connect out to datasources? I need to add those IPs to the firewall.
I could only find this page, but it only mentions the IP Addresses that clients will be connecting to Dremio-Cloud on. Connecting Client Applications to Dremio | Dremio Documentation
If I’m not mistaken, to connect to external databases, it should be just the IP address of what you’ve got in your Preview Engine.
The only IP address I see for my engine is an internal IP address. I need to know the public IP of requests that originate from Dremio-Cloud and go to a database service’s public IP address. The database service has a firewall, and I have to add IPs (or ranges) to it.
This is interesting. I’m seeing a lot of different public IPs showing up. Like, so many different ones that I can’t reasonably add them all to the allow list. I presume that means whenever a new engine starts up it has a different public IP.
How do people solve this?
@capnjosh Which external DB are you trying to connect?
In this case, it is an Azure SQL database that has a restrictive firewall in front of it. Only clients coming from public IP addresses that are allowed in through that firewall can even connect.
Currently, Dremio connections seem to originate from a huge range of IP addresses, so I don’t know what to add to the Azure SQL firewall to support incoming Dremio requests. Is there some way to have all my Dremio requests come from a limited range of public IPs? Or, how can I determine the range of IPs I would need to allow in?