Create a new Data Push Job in a Data Pool

Request

path Parameters

poolId

required

string

query Parameters

validate

boolean

Default: false

Request Body schema: application/json

allowDuplicate	boolean
changeDate	string <date-time>
connectionId	string
creationDate	string <date-time>
	object (CSVParsingOptions)
dataPoolId	string
fallbackVarcharLength	integer <int32>
fileType	string (UploadFileType) Enum: "PARQUET" "CSV"
foreignKeys	string
id	string
keys	Array of strings
lastModified	string <date-time>
lastPing	string <date-time>
logs	Array of strings
mirrorTargetNames	Array of strings
optionalTenantId	string
postExecutionQuery	string
sanitizedPostExecutionQuery	string
status	string (JobStatus) Enum: "NEW" "QUEUED" "RUNNING" "DONE" "ERROR" "CANCELED"
	object (TableTransport)
targetName	string
targetSchema	string
tenantId	string
type	string (JobType) Enum: "REPLACE" "DELTA"
upsertStrategy	string (DataPushUpsertStrategy) Enum: "UPSERT_WITH_UNCHANGED_METADATA" "UPSERT_WITH_NULLIFICATION"

Responses

200

204

No Content

400

Bad Request

403

Forbidden

404

Not Found

429

Too Many Requests

500

Internal Server Error

post/api/v1/data-push/{poolId}/jobs/

Request samples

application/json

{"allowDuplicate": true,
"changeDate": "2019-08-24T14:15:22Z",
"connectionId": "string",
"creationDate": "2019-08-24T14:15:22Z",
"csvParsingOptions": {"additionalColumnOptions": [{"columnName": "string",
"dateFormat": "string",
"decimalSeparator": "string",
"thousandsSeparator": "string"
}
],
"charSet": "string",
"dateFormat": "string",
"decimalSeparator": "string",
"escapeSequence": "string",
"lineEnding": "string",
"quoteSequence": "string",
"separatorSequence": "string",
"thousandSeparator": "string"
},
"dataPoolId": "string",
"fallbackVarcharLength": 0,
"fileType": "PARQUET",
"foreignKeys": "string",
"id": "string",
"keys": ["string"
],
"lastModified": "2019-08-24T14:15:22Z",
"lastPing": "2019-08-24T14:15:22Z",
"logs": ["string"
],
"mirrorTargetNames": ["string"
],
"optionalTenantId": "string",
"postExecutionQuery": "string",
"sanitizedPostExecutionQuery": "string",
"status": "NEW",
"tableSchema": {"columns": [{"columnName": "string",
"columnType": "INTEGER",
"decimals": 0,
"fieldLength": 0,
"pkField": true
}
],
"tableName": "string"
},
"targetName": "string",
"targetSchema": "string",
"tenantId": "string",
"type": "REPLACE",
"upsertStrategy": "UPSERT_WITH_UNCHANGED_METADATA"
}

Response samples

application/json

{"allowDuplicate": true,
"changeDate": "2019-08-24T14:15:22Z",
"connectionId": "string",
"creationDate": "2019-08-24T14:15:22Z",
"csvParsingOptions": {"additionalColumnOptions": [{"columnName": "string",
"dateFormat": "string",
"decimalSeparator": "string",
"thousandsSeparator": "string"
}
],
"charSet": "string",
"dateFormat": "string",
"decimalSeparator": "string",
"escapeSequence": "string",
"lineEnding": "string",
"quoteSequence": "string",
"separatorSequence": "string",
"thousandSeparator": "string"
},
"dataPoolId": "string",
"fallbackVarcharLength": 0,
"fileType": "PARQUET",
"foreignKeys": "string",
"id": "string",
"keys": ["string"
],
"lastModified": "2019-08-24T14:15:22Z",
"lastPing": "2019-08-24T14:15:22Z",
"logs": ["string"
],
"mirrorTargetNames": ["string"
],
"optionalTenantId": "string",
"postExecutionQuery": "string",
"sanitizedPostExecutionQuery": "string",
"status": "NEW",
"tableSchema": {"columns": [{"columnName": "string",
"columnType": "INTEGER",
"decimals": 0,
"fieldLength": 0,
"pkField": true
}
],
"tableName": "string"
},
"targetName": "string",
"targetSchema": "string",
"type": "REPLACE",
"upsertStrategy": "UPSERT_WITH_UNCHANGED_METADATA"
}