@Javier De La Torre do you really need two-way SSL (verify-full)? In most cases one way SSL (sslmode=require) should be enough.

@akj2784​  When you say "Connection was successful", where do you mean you established a successful connection? You might be missing the

.option("ssl", True) \ .options("sslmode", "require")