create_extract
Create a data extract job that moves data from a source dataset to a target database table, applying dimension and aggregate columns.
Instructions
Create a CDV data extract job.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| src_dataset_id | Yes | Source dataset ID. | |
| tgt_dataconnection_id | Yes | Target data connection ID. | |
| tgt_dbname | Yes | Target database name. | |
| tgt_tablename | Yes | Target table name. | |
| dim_data | Yes | JSON string of dimension columns, e.g. '[{"expr":"[col]","alias":"col"}]'. | |
| agg_data | Yes | JSON string of aggregate columns, e.g. '[{"expr":"sum([col])","alias":"col"}]'. | |
| partition_data | No | JSON string of partition columns for incremental refresh (default '[]'). | [] |
| schedule_id | No | Optional schedule ID to attach a job to the extract. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |