secure

Job Dry Run

Executes a job using input data in a dry-run mode.

post/api/v1/pipelines/jobs/dry-run

Request body

input_dataobject[] required

Example request

{
  "job": {
    "source": {
      "schema": "public",
      "table": "employee",
      "row_format": "full"
    },
    "transform": [
      {
        "uses": "add_field",
        "with": {
          "expression": "FNAME || ' ' || LAST_NAME",
          "field": "FullName",
          "language": "sql"
        }
      }
    ],
    "output": [
      {
        "uses": "redis.write",
        "with": {
          "expression": "FNAME || ' ' || LAST_NAME",
          "field": "FullName",
          "language": "sql"
        }
      }
    ],
    "name": "Alex"
  },
  "input_data": [
    {
      "COUNTRY": "IL",
      "FNAME": "John",
      "LAST_NAME": "Lennon"
    },
    {
      "COUNTRY": "US",
      "FNAME": "John",
      "LAST_NAME": "Doe"
    }
  ]
}

Response

Successful Response

Example response

{
  "transformation": [
    {
      "COUNTRY": "IL",
      "FIRST_NAME": "John",
      "LAST_NAME": "Lennon"
    }
  ]
}

Changes

Changed in 5 of the 14 revisions of this API.282123

Jul 16, 2026e381b64b5ffc41216See the full diff
- ▲
  the ////// request property type changed from object to no type
  request-property-type-changed
- ▲
  the ///// request property type changed from object to no type
  request-property-type-changed
- ▲
  the /////// request property type changed from object to no type
  request-property-type-changed
- ▲
  the ////// request property type changed from object to no type
  request-property-type-changed
- ●
  removed the request property ///////
  request-property-removed
- ●
  removed the request property ///////
  request-property-removed
- ●
  removed the request property ///////
  request-property-removed
- ●
  removed the request property //////
  request-property-removed
- ●
  removed the request property //////
  request-property-removed
- ●
  removed the request property //////
  request-property-removed
- ●
  removed the request property ////////
  request-property-removed
- ●
  removed the request property ////////
  request-property-removed
- ●
  removed the request property ////////
  request-property-removed
- ●
  removed the request property ///////
  request-property-removed
- ●
  removed the request property ///////
  request-property-removed
- ●
  removed the request property ///////
  request-property-removed
- ○
  added the new optional request property /////
  new-optional-request-property
- ○
  added the new optional request property /////
  new-optional-request-property
- ○
  added the new optional request property /////
  new-optional-request-property
- ○
  added the new optional request property //////
  new-optional-request-property
- ○
  added the new optional request property //////
  new-optional-request-property
- ○
  added the new optional request property //////
  new-optional-request-property
- ○
  added to the ////// request property anyOf list
  request-property-any-of-added
- ○
  added to the /////// request property anyOf list
  request-property-any-of-added
- ○
  added subschema #2 to the ///// request property anyOf list
  request-property-any-of-added
- ○
  added subschema #2 to the ////// request property anyOf list
  request-property-any-of-added
- ○
  added to the /// request property anyOf list
  request-property-any-of-added
- ○
  added to the //// request property anyOf list
  request-property-any-of-added
- ○
  the request property ///// became optional
  request-property-became-optional
- ○
  the request property ////// became optional
  request-property-became-optional
- ○
  request property ///// list-of-types was widened by adding types array to media type application/json
  request-property-list-of-types-widened
- ○
  request property ////// list-of-types was widened by adding types array to media type application/json
  request-property-list-of-types-widened
Feb 3, 2026dbbdeb97f6101See the full diff
- ▲
  added required request body
  request-body-added-required
Feb 2, 2026f0a3d26cc0c612See the full diff
- ▲
  removed the request body
  request-body-removed
- ●
  removed the optional property from the response with the status
  response-optional-property-removed
- ●
  removed the optional property from the response with the status
  response-optional-property-removed
This revision also has 9 changes that name no endpoint, such as unreferenced schemas being removed. See the revision's changelog
Jun 16, 2025557b7644b94312See the full diff
- ●
  removed the request property //
  request-property-removed
- ○
  added the optional property to the response with the status
  response-optional-property-added
- ○
  added the optional property to the response with the status
  response-optional-property-added
Feb 27, 2025b0ed6c7dac422265See the full diff
- ▲
  added the new required request property ///////
  new-required-request-property
- ▲
  added the new required request property ///////
  new-required-request-property
- ▲
  added the new required request property //////
  new-required-request-property
- ▲
  added the new required request property //////
  new-required-request-property
- ▲
  added the new required request property ////////
  new-required-request-property
- ▲
  added the new required request property ////////
  new-required-request-property
- ▲
  added the new required request property ///////
  new-required-request-property
- ▲
  added the new required request property ///////
  new-required-request-property
- ▲
  removed from the ////// request property anyOf list
  request-property-any-of-removed
- ▲
  removed from the /////// request property anyOf list
  request-property-any-of-removed
- ▲
  removed subschema #2 from the ///// request property anyOf list
  request-property-any-of-removed
- ▲
  removed subschema #2 from the ////// request property anyOf list
  request-property-any-of-removed
- ▲
  removed from the /// request property anyOf list
  request-property-any-of-removed
- ▲
  removed from the //// request property anyOf list
  request-property-any-of-removed
- ▲
  the request property ///// became required
  request-property-became-required
- ▲
  the request property ////// became required
  request-property-became-required
- ▲
  request property ///// list-of-types was narrowed by removing types array from media type application/json
  request-property-list-of-types-narrowed
- ▲
  request property ////// list-of-types was narrowed by removing types array from media type application/json
  request-property-list-of-types-narrowed
- ▲
  the ////// request property type changed from no type to object
  request-property-type-changed
- ▲
  the ///// request property type changed from no type to object
  request-property-type-changed
- ▲
  the /////// request property type changed from no type to object
  request-property-type-changed
- ▲
  the ////// request property type changed from no type to object
  request-property-type-changed
- ●
  removed the request property /////
  request-property-removed
- ●
  removed the request property /////
  request-property-removed
- ●
  removed the request property /////
  request-property-removed
- ●
  removed the request property //////
  request-property-removed
- ●
  removed the request property //////
  request-property-removed
- ●
  removed the request property //////
  request-property-removed
- ○
  added the new optional request property ///////
  new-optional-request-property
- ○
  added the new optional request property //////
  new-optional-request-property
- ○
  added the new optional request property //
  new-optional-request-property
- ○
  added the new optional request property ////////
  new-optional-request-property
- ○
  added the new optional request property ///////
  new-optional-request-property
This revision also has 37 changes that name no endpoint, such as unreferenced schemas being removed. See the revision's changelog

Full history