Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| interface_id | varchar | 100 | null |
|
|
Unique interface name to represent a batch execution. Part of the composite PK, with execution_id column. |
|||||
| execution_id | int4 | 10 | null |
|
|
Execution ID number to represent a instance of interface_id. Part of the composite PK, with interface_id column. |
|||||
| execution_parent_id | int4 | 10 | √ | null |
|
|
Reference to a parent execution ID that groups one or more execution_id in a batch run. If null, then this execution_id is a parent. |
||||
| execution_order | int4 | 10 | √ | null |
|
|
Order of execution of this instance in a collection of same execution_parent_id. Execution runs in ascending order. If it is less than 0, it will not run. |
||||
| source_file | varchar | 200 | √ | null |
|
|
Source instruction file for batch execution |
||||
| source_db_type | varchar | 200 | √ | null |
|
|
Database type of the source connection. Expected ORACLE or POSTGRES. |
||||
| source_name | varchar | 100 | √ | null |
|
|
Source name of this batch execution |
||||
| source_table | varchar | 100 | √ | null |
|
|
Source table (if it is a single table) of this batch execution |
||||
| target_file | varchar | 200 | √ | null |
|
|
Target instruction file for batch execution |
||||
| target_db_type | varchar | 200 | √ | null |
|
|
Database type of the target connection. Expected ORACLE or POSTGRES. |
||||
| target_name | varchar | 100 | √ | null |
|
|
Target name of this batch execution |
||||
| target_table | varchar | 100 | √ | null |
|
|
Target table (if it is a single table) of this batch execution |
||||
| target_primary_key | varchar | 100 | √ | null |
|
|
Primary key of the target table of this batch execution |
||||
| truncate_before_run | bool | 1 | false |
|
|
If the target table should be truncated before the batch execution |
|||||
| retry_errors | bool | 1 | false |
|
|
If true, this process will execute again old instances with errors in ETL_EXECUTION_LOG_HIST |
|||||
| updated_at | timestamp | 29,6 | now() |
|
|
Timestamp of the last time this record was updated |
|||||
| created_at | timestamp | 29,6 | now() |
|
|
Timestamp of the time this record was created |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| etl_execution_map_pk | Primary key | Asc/Asc | interface_id + execution_id |
Relationships
Close relationships within degrees of separation
