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".