6.Connect - AWS-Postgresql with Databricks

[@nitikjain993]

Thanks
Could you please make more video like this how to connect differnet differnet databases with databrick with jdbc to read data from there and how to transform such data in databrick
Its so helpfull if you make some more videos like that

[@datafunx]

Will try my best

[@nitikjain993]

I m using RDS aurora mysql but getting this error:ClassNotFoundException: com.mysql.jdbc.Driver
I have run this command only :Class.forName (“com.mysql.jdbc.Driver”)
please help

[@datafunx]

Hi,
Sorry for the delayed response.
Click on the below link and download the jar file on your system.
dev.mysql.com/downloads/connector/j/5.1.html
Then upload this "jar" file in databricks workspace by right clicking on any folder and "create library".
Once the file is uploaded you can attach this library to the working cluster.
after this you can type the below code, however it is not necessary in this case, and the driver will be loaded automatically.
However, if you still want to use this you are free to use.
%scala
Class.forName("com.mysql.cj.jdbc.Driver")
You will get the below response :
res5: Class[_] = class com.mysql.cj.jdbc.Driver

[@navaneethm8280]

How to connect RDS MySQL to databricks can u tell

[@datafunx]

Hi,
Use the below jdbcURL :
“jdbc:mysql://{}/{}”.format (HOST,DATABASE_NAME)
Load MYSQL driver as below, in scala
Class.forName (“com.mysql.jdbc.Driver”)