modzyClient.submitJobJDBC

modzyClient.submitJobJDBC(String modelId, String versionId, String url, String username, String password, String driver, String query)

Submits a job based on a SQL query made on a database accessed through JDBC.

Parameters

Parameter	Type	Description	Example
`modelId`	`java.lang.String`	Model identifier provided by Modzy.	`"ed542963de"`
`versionId`	`java.lang.String`	The model’s version number. It follows the semantic versioning format.	`"1.0.1"`
`url`	`java.lang.String`	JDBC url to connect to the database	`'jdbc:postgresql://database-host:5432/mydatabase'`
`username`	`java.lang.String`	The username to access the database	`'username'`
`password`	`java.lang.String`	The password to access the database	`'password'`
`driver`	`java.lang.String`	The query to execute, notice that we will try to match the column names to the model input keys, so you'll need to use alias for that.	`'select description as \'input.txt\' from my-table'`
`query`	`java.lang.String`	If the model supports explainability, flag this job to return an explanation of the predictions	`True`

Returns

com.modzy.sdk.model.Job object with the job status obtained from the server

Examples

Job job = modzyClient.submitJobJDBC("ed542963de", "1.0.1", "jdbc:postgresql://database-host:5432/mydatabase", "username", "password", "org.posgresql.Driver", "select description as \'input.txt\' from my-table");

More specific customization options are provided by the method [modzyClient.getJobClient.submitJob]{doc:javamodzyclientsubmitjob}

JobInput<String> jobInput = new JobInputJDBC("jdbc:postgresql://database-host:5432/mydatabase", "username", "password", "org.posgresql.Driver", "select description as \'input.txt\' from my-table");   
Job job = modzyClient.submitJob("ed542963de", "1.0.1", jobInput, false);