As part of our solution approach, we need to connect to one of our AWS RDS Oracle databases from Azure Databricks notebook.
We need your help to understand which IP range of Azure Databricks to consider to whitelist them on AWS RDS security group, so that we can access AWS RDS Oracle DB from our Azure Databricks notebook.
Please advise if we need perform any additional steps on Azure/Databricks side.
@Mahesh D :
To connect to an AWS RDS Oracle database from Azure Databricks, you need to whitelist the Azure Databricks IP range in the AWS RDS security group.
The IP range of Azure Databricks varies based on the region and deployment mode. You can find the IP range of Azure Databricks in your region and deployment mode from the the documentation.
Once you have the IP range of Azure Databricks, add it to the AWS RDS security group as an inbound rule for the Oracle database. You can refer to the following AWS documentation for more details on how to add inbound rules to security groups: https://docs.aws.amazon.com/vpc/latest/userguide/VPC_SecurityGroups.html#AddRemoveRules
On the Azure Databricks side, you need to ensure that you have the necessary JDBC driver to connect to the Oracle database. You can download the JDBC driver from the Oracle website and upload it to Azure Databricks. Once you have the JDBC driver, you can use the standard JDBC connection method to connect to the Oracle database from Azure Databricks.
Hi @Mahesh D
Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.
We'd love to hear from you.
Hi @Suteja Kanuri & @Vidula Khanna ,
Thanks for the info and the follow up.
I'm clear about the part "IP range of Azure Databricks in your region". I could find that the below IP range is meant for Australia East region where our Databricks workspace is created. We are pretty clear on what to do on AWS but we need more help from Azure perspective as we are new to it.
Webapp - 184.108.40.206/32
SCC relay (if SCC is enabled) - tunnel.australiaeast.azuredatabricks.net
Control Plane NAT (if SCC is disabled) - 220.127.116.11/32
Extended infrastructure - 18.104.22.168/28
But I'm unsure of what is the deployment mode of our Databricks workspace.
Could you kindly advise how can I find out what is the deployment mode for our databricks workspace? And also, which IP range in specific from above we need to whitelist on our AWS RDS security groups?
Appreciate your help.
@Mahesh D :
You can find the deployment mode of your Databricks workspace in the Azure portal.
Once you know the deployment mode, you can determine which IP range to whitelist on your AWS RDS security group.
If your workspace is deployed using Azure Databricks Standard SKU, you will need to whitelist the IP range for the "Control Plane NAT" listed in your region's IP range list. If your workspace is deployed using Azure Databricks Premium SKU, you will need to whitelist the IP range for the "Webapp" listed in your region's IP range list.
In your case, since your Databricks workspace is deployed in Australia East, you will need to whitelist the IP range "22.214.171.124/32" on your AWS RDS security group if your workspace is deployed using Azure Databricks Standard SKU. If your workspace is deployed using Azure Databricks Premium SKU, you will need to whitelist the IP range "126.96.36.199/32" on your AWS RDS security group.
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!