Hi there,

i am trying to set yp the connection to a PlanetScale MySQL database. I have followed all of the configuration steps but receive the following:

remote_table = (spark.read

.format("jdbc")\

.option("driver", driver)\

.option("url", url)\

.option("dbtable", table)\

.option("user", username)\

.option("password", passwd)\

.option("ssl", True) \

.options("sslmode", "require" ) \

.options("sslcert", "dbfs:/mnt/*****-data-landing/admin/my_cert.pem") \

.load()

)

error message:

TypeError: options() takes 1 positional argument but 3 were given

--------------------------------------------------------------------------- TypeError Traceback (most recent call last)

<command-3539186329914624> in <module>

12 url = "<url_path>"

13 --->

14 remote_table = (spark.read

15 .format("jdbc")\

16 .option("driver", driver)\

TypeError: options() takes 1 positional argument but 3 were given

I am aware this Type error is a bit of a needle in a haystack kind of situation but if anyone has come across this before or can see anything obvious in my setup. First time connecting to MySQL in Datarbicks. Thanks