extractor_column

Defines a column in an extractor output

Primary Key:

• extractor_column_id

Foreign Keys:

• data_type_id => extractor_column_data_type.extractor_column_data_type_id
• extractor_output_id => extractor_output.extractor_output_id
• referenced_output_id => extractor_output.extractor_output_id

Indexes:

• extractor_column_data_type_id_idx - data_type_id
• extractor_column_extractor_output_id_name_uq (Unique) - extractor_output_id, name
• extractor_column_referenced_output_id_idx - referenced_output_id

Column	Data Type	Nullable	Indexed	Description
extractor_column_id	bigint	No	Yes	Snowflake ID for the column Generated through expression:
extractor_output_id	bigint	No	Yes	The output the column belongs to Generated through expression:
name	text	No	Yes	Column name Generated through expression:
referenced_output_id	bigint	Yes	Yes	The output the column refers to. Used when the column is a foreign ID. Generated through expression:
referenced_output_row_name	text	No	No	The output row the column refers to. Used when the column is a foreign ID. Generated through expression:
data_type_id	bigint	Yes	Yes	Column data type Generated through expression:
length	integer	Yes	No	Required value length Generated through expression:
min_length	integer	Yes	No	Minimum value length Generated through expression:
max_length	integer	Yes	No	Maximum value length Generated through expression:
default_value	text	No	No	Default value Generated through expression:
header_regex	text	No	No	Regex used to match input header names for auto-mapping Generated through expression:
linked_column_name	text	No	No	Used when the same data value should be loaded into multiple tables Generated through expression: