https://community.databricks.com/t5/get-started-discussions/how-to-install-aws-pem-file-in-databricks-cluster-to-make-a-db/m-p/38666#M5617 <P>I am trying to make a connection between AWS Mysql RDS and Databricks. I am using the below code to establish the connection. But its failed due to certificate is not installed.&nbsp;</P><P>I have the .pem file with me. Could anyone help on how install this in Databricks cluster and establish the connection to RDS.</P><P>Below is the connection properties I used.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="python">table = "test_table" database_host = "test-db-dev.cluster-ro-pkh5s13hvg.us-west-2.rds.amazonaws.com" database_port = "3306" database_name = "test_db" user = "test_user" password = "12345678" url = f"jdbc:mysql://{database_host}:{database_port}/{database_name}" df_rds_table = spark.read \ .format("jdbc") \ .option("driver","com.mysql.cj.jdbc.Driver") \ .option("url", url) \ .option("dbtable", table) \ .option("user", user) \ .option("password", password) \ .load()</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 28 Jul 2023 12:51:47 GMT DineshKumar 2023-07-28T12:51:47Z https://community.databricks.com/t5/get-started-discussions/how-to-install-aws-pem-file-in-databricks-cluster-to-make-a-db/m-p/38666#M5617 <P>I am trying to make a connection between AWS Mysql RDS and Databricks. I am using the below code to establish the connection. But its failed due to certificate is not installed.&nbsp;</P><P>I have the .pem file with me. Could anyone help on how install this in Databricks cluster and establish the connection to RDS.</P><P>Below is the connection properties I used.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="python">table = "test_table" database_host = "test-db-dev.cluster-ro-pkh5s13hvg.us-west-2.rds.amazonaws.com" database_port = "3306" database_name = "test_db" user = "test_user" password = "12345678" url = f"jdbc:mysql://{database_host}:{database_port}/{database_name}" df_rds_table = spark.read \ .format("jdbc") \ .option("driver","com.mysql.cj.jdbc.Driver") \ .option("url", url) \ .option("dbtable", table) \ .option("user", user) \ .option("password", password) \ .load()</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 28 Jul 2023 12:51:47 GMT https://community.databricks.com/t5/get-started-discussions/how-to-install-aws-pem-file-in-databricks-cluster-to-make-a-db/m-p/38666#M5617 DineshKumar 2023-07-28T12:51:47Z https://community.databricks.com/t5/get-started-discussions/how-to-install-aws-pem-file-in-databricks-cluster-to-make-a-db/m-p/39323#M5618 <P>Hi, Could you please provide the error code or the full error stack? Please tag&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/26078">@Debayan</a>&nbsp;with your next comment which will notify me. Thank you!</P> Tue, 08 Aug 2023 06:44:27 GMT https://community.databricks.com/t5/get-started-discussions/how-to-install-aws-pem-file-in-databricks-cluster-to-make-a-db/m-p/39323#M5618 Debayan 2023-08-08T06:44:27Z