Error:

JDBC Origin throws an error: java.sql.SQLException: No suitable driver

Resolution:

Make sure that you are using the latest build as we have added logic for auto-detecting driver and passing it down to spark automatically.

Alternatively, if you observe it, try passing new config “driver” ---> “com.mysql.jdbc.Driver” in JDBC Origin ---> “Additional JDBC Configuration Properties”.

MySQL driver = “com.mysql.jdbc.Driver”

Microsoft MS SQL driver = “com.microsoft.sqlserver.jdbc.SQLServerDriver”

Postgres driver = “org.postgresql.Driver”

NOTE:  If you don't have the latest and adding additional JDBC config doesn't work, upload the driver (via Package Manager in Transformer) and set JDBC Driver to "Bundle driver from connection string".