Skip to main content

extractor_wizard_map_output

Stores wizard map outputs, which specify how input columns are transformed into output rows

Primary Key:

extractor_wizard_map_output_id

Foreign Keys:

exclude_column_group_id => extractor_column_group.extractor_column_group_id
include_column_group_id => extractor_column_group.extractor_column_group_id
extractor_output_reference_id => extractor_output_reference.extractor_output_reference_id
always_include_parent_map_output_id => extractor_wizard_map_output.extractor_wizard_map_output_id

Indexes:

extractor_wizard_map_output_exclude_column_group_id_idx - exclude_column_group_id
extractor_wizard_map_output_extractor_output_reference_id_idx - extractor_output_reference_id
extractor_wizard_map_output_include_column_group_id_idx - include_column_group_id
extractor_wizard_map_output_parent_map_output_id_idx - always_include_parent_map_output_id

Column	Data Type	Nullable	Indexed	Description
`extractor_wizard_map_output_id`	`bigint`	No	Yes	Snowflake ID for the map output Generated through expression:
`header_regex`	`text`	No	No	Regex used to match input header names for auto-mapping Generated through expression:
`always_include_parent_map_output_id`	`bigint`	Yes	Yes	A map output, like its corresponding table, may depend on another map output. For example, the provider_seen table is dependent on claim_provider (its parent). In some cases, when a child has data, we must also include the parent for everything to work. This option ensures a parent row is output whenever a child has data. Generated through expression:
`include_column_group_id`	`bigint`	Yes	Yes	Group of output columns to include. If null, all output columns for the output are included. Generated through expression:
`exclude_column_group_id`	`bigint`	Yes	Yes	Group of output columns to exclude. Note that exclusion takes precedence over inclusion (e.g., if a column is in both the include and exclude list, it will be excluded). Generated through expression:
`extractor_output_reference_id`	`bigint`	No	Yes	The related output reference Generated through expression:
`force_output`	`boolean`	No	No	Whether to force the output to be created if nothing is mapped for it in the input template Generated through expression: