| Name | Description | JSON Data Type | Required |
|---|---|---|---|
| name | String | Yes | |
| ownerName | String | No | |
| stagingDatabase or targetStagingDatabase
These parameters are interchangeable; you can use either, but not both at the same time. |
String | No | |
| sourceStagingDatabase | String | No | |
| stagingDatabaseForTable | String | No | |
| targetDatabase | String | No | |
| targetName | String | No | |
| validateRowCount | String | No | |
| compareDDL | Boolean | No | |
| ForceTargetStagingTable | Boolean | No | |
| selection | String | Yes | |
| exportWithoutSpool | Boolean | No | |
| partialTableParameters | Encapsulates properties needed for partial table | Object (PartialTableType) | No |
| teradataParameters | Parameters relevant for Teradata to Teradata jobs only | Object (TDTableType) | No |
| column | Specifies columns | JSON Array (ColumnType) | No |
| dbClientEncryption | Boolean | No | |
| map | Map name | String | No |
| colocate | Colocation name | String | No |
| stagingToTarget | Specifies how to move data from a staging table to a target table. Valid values are NOT_SPECIFIED, DELETE_INSERT, MERGE, INSERT_ONLY, DELETE_DISTINCT_INSERT |
String | No |
| useSourceStagingTable | Specifies if a job needs to use a source staging table. | Boolean | No |