getTableIntersection
This procedure compares the metadata of the source and target and generates the column lists for data download based on the intersection of the columns in the source and target. It also allows adding the mandatory columns at the beginning and the end of the resultset by using the corresponding parameters. The values for these columns are not returned in source_columns
and must be specified explicitly in the consuming procedure.
Parameters
Parameter | Description |
---|---|
source_dataset | Fully-qualified name of the source. Can be an existing table or a stored procedure returning data. Can also be an arbitrary table specification in the form of a string: $column1|dataType1,column2|dataType3,column3[|string] returning data; mandatory |
target_table | Fully-qualified name of the target. Must be an existing table; mandatory |
isSourceATable | TRUE or NULL if the source is a table, FALSE if it is a procedure |
collapseEqualDatasets | Returns a simple * if the metadata of source and target fully matches |
renamedColumns | Comma-separated list of columns pairs separated by vertical bars: NameInTarget1|NameInSource1, NameInTarget1|NameInSource1 |
ignoredColumnChanges | Comma-separated list of columns for which no warning should be raised (which are expected due to the intended logic or known changes) |
excludedColumns | Columns to exclude from the source |
columnListFirst | Columns to add in the beginning |
columnListLast | Columns to add in the end |
Attributes
Attribute | Type |
---|---|
| clob |
| clob |
Columns that only exist in the source or target are excluded from the output. Columns with the same names but different data types will be attempted to be converted automatically using UTILS.tryCast
. If the cast fails, NULL
values will be inserted.