 Hello, and welcome back. So shall decide and this is continuation of Azure Databricks tutorial. So in the today's video We are going to see how we can connect our Azure Databricks to the Azure SQL. It's very straightforward We have to use this JDBC connectivity and you have to use the URL So basically we should be going to use the driver So driver is the JDBC driver by which we are going to connect with the Azure SQL and after that We have to add the database host. So database host is nothing but the server name and then the port So for the SQL it should be 1433 then we have to add the database name Then the table name that we want to access and after that we have to add the user ID and password and Inside the URL we will be going to add the database host that we can see we are putting in this variable So that we are going to use and after that after the column We are going to supply the port name that is 1433 Then semicolon we had to add and after that we need to add the database name So it will be going to have your URL then after we have to use one of the property of the Spark so that is the spark dot read and after that inside the options We will be providing the option for the URL and under that URL We are going to use this variable as an URL so it will be going to make the connection and We'll be reading the data from the table that we are also supplying inside the option of the DB table and Again we have to add the user ID and password for that particular database connectivity so let me quickly go inside the SQL server and Here we want to access this table, which is the country master and this country master We want to access inside the Azure Databricks, so let me quickly go inside the Azure Databricks workspace and here I have already created this notebook. So here, let me try to start the cluster So it will take a little bit time let me quickly go and try to copy the syntax and Let me quickly go and paste inside this workspace notebook. Here you have to add the values So the first thing driver would remain same. You need to update the database host So your database host will be the server name. We can get it from here So let me try to click on this. So this will be your Database server so we can copy it and after that you can go and Try to paste it there. So this will be your Server name port name will remain same then the database name So we want to make the connection with the Survey underscore MTO GST. So this is your database name. So we can add the database name here Now we need to add the table name by which we want to make the connection So inside the table name, we want to access the country master So this country master we can copy and paste it there So we got all these values next will be your user ID and then we need to supply the password So I'm going to copy the user ID from here That we are using for this login credential You need to provide your login credential here your table name your database name your server name So these values you need to add as per your server and login credentials. Now, let me add the password here So after adding the password once we will be going to run this cell by Pressing shift enter. So it will be run and all these variables will be holding the values So as we can see it is Having the values next we need to use the spark sequel command. So this is the command. Let me try to copy it So don't worry. I'll be going to provide this command on the description of this video So you can use without any issue here. We are not required to make any changes all These things will remain same because as we can see we are having the Driver so driver is this we are holding in a variable then the URL URL will be holding in this variable Database table so database table will be holding in this variable Then the user ID and password so that is holding in these two variables So all these we have put inside the variables and those variables we are going to access here Let me try to execute it So once we will be executing and here we are using the display. So this Remote table data frame will be having the values and inside the display We are going to see like ID location and effective date the same data that we can see here as well like ID Location and data frame and the effective date. Thank you so much for watching this video. See you in the next video