IP's of notebooks within Fabric to connect to vendor DB

[cstoddard]

Hi,

I need to connect to a vendor's MSSQL DB. I can't do so as they need to whitelist the IP's from which I'm connecting, and I can't find a list of the Spark notebook's IP's.

I've gotten some IP's by making a GET request to a website, here's the IP's I have collected so far:

4.426.105.239

20.125.49.30

4.155.93.61

4.154.219.255

Here is the code of how I got these IP's that I just ran within the notebook in Fabric:

import requests

res = requests.get("http://checkip.dyndns.com")

print(res.text)

I don't see these IP's mentioned anywhere within the list of IP's and service tags. 

Could someone please let me know what I should do?

Thanks!

[v-nikhilan-msft · Accepted solution]

Hi @cstoddard 
We don't support SNAT(Source Network Address Translation). The Spark notebook doesn't have deterministic IP address. 

Appreciate if you could share the feedback on our feedback link , which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.        
Feedback Link : Home (microsoft.com)

Hope this helps. Please let us know if you have any further queries.

[HimanshuS-msft]

Hello @cstoddard 
Thanks for using the Fabric community.

Just trying to understand as to what is the intend here . You mentioned that the you have MSSQL DB , which as i understand is an in-premise setup and hence the Spark notebook cannot connect to that .

Did you meant that you have Azure SQL and mananged SQL setup ? We do have that the IP range called out for all the Azure Services here : https://www.microsoft.com/en-us/download/details.aspx?id=56519

Thanks
HImanshu

[cstoddard]

I'm trying to connect to an MSSQL server that is provided by a vendor. I'm trying to use a Spark notebook to do so, here's the code:

server_name = "jdbc:sqlserver://xxx:1433"
database_name = "xxx"

table_name = "database.xxx"
username = "xxx"
password = "xxx" # Please specify password here
 
url = f"{server_name};user={username};password={password};"

df = spark.read.jdbc(url=url, table=table_name)

To be able to connect to the MSSQL DB that I need to connect to, I need the IP of the notebook to be whitelisted. There are IPs that are being used by the Spark notebook that are not in that list provided. I know this, because I'm running the code which I mentioned in my first post that shows the IP, and those IPs are not in that JSON dump of IPs provided by Microsoft.

Does that make more sense?

[cstoddard]

Dump*, not dumb. Sorry for the typo

[v-nikhilan-msft · Accepted solution]

Hi @cstoddard 
We don't support SNAT(Source Network Address Translation). The Spark notebook doesn't have deterministic IP address. 

Appreciate if you could share the feedback on our feedback link , which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.        
Feedback Link : Home (microsoft.com)

Hope this helps. Please let us know if you have any further queries.

[v-nikhilan-msft · Accepted solution]

Hi @cstoddard 

We haven’t heard from you on the last response and was just checking back to see if you got some insights regarding your query. Otherwise, will respond back with the more details and we will try to help.
Thanks