Run a Job
POST/scheduler/startRun
Create a new refresh Job.
Request
- application/json
Body
runDetails
object
required
Object containing the necessary target details required to successfully start a refresh.
The environment being refreshed
Nodes included for an ad-hoc job
Nodes excluded for an ad-hoc job.
The ID of a job being run.
Default value: 16
Maximum number of parallel nodes to run.
Allows refreshing an environment even if the last deployment on that environment failed. Use with caution as this can put your environment into an even worse state.
userCredentials
object
userCredentials contains connection credentials for connecting to Snowflake. Currently only basic auth (username/password) may be specified. If however, an OAuth connection has been established for the given environment specified in runDetails.environmentID, you may omit userCredentials. In that case, Coalesce will use the OAuth connection to connect with Snowflake.
Snowflake Account Username. Required when snowflakeAuthType is Basic and KeyPair Auth
Snowflake Account password. Required when snowflakeAuthType is Basic
The PEM-encoded private key to use when authenticating to Snowflake. Required when using the KeyPair authentication type. Newlines must be encoded as "\n" within the request.
The password to use to decrypt the private key. This is only applicable when the authentication type is KeyPair and the private key is encrypted.
Snowflake compute warehouse
Snowflake user role
Default value: Basic
Options: Basic | KeyPair | OAuth
Contains parameters to be used in the Refresh
Responses
- 200
- 400
- 401
200
- application/json
- Schema
- Result
Schema
Default value: 0
{
"runCounter": 1
}
400
- application/json
- Schema
- Result
Schema
error
object
{
"error":{
"errorString":"400: Error Message",
"errorDetail":"400: Error Message"
}
}
401
- application/json
- Schema
- Result
Schema
error
object
{
"error":{
"errorString":"401: Unable to authenticate, please ensure your token is valid.",
"errorDetail":"401: Unable to authenticate, please ensure your token is valid."
}
}