extractor_column

Extractor output columns

Primary Key:

• extractor_column_id

Foreign Keys:

• created_by => login.login_id
• data_type_id => extractor_column_data_type_lookup.extractor_column_data_type_id
• extractor_output_version_id => extractor_output_version.extractor_output_version_id
• referenced_output_id => extractor_output.extractor_output_id

Indexes:

• extractor_column_created_by_idx - created_by
• extractor_column_data_type_id_idx - data_type_id
• extractor_column_extractor_output_version_id_idx - extractor_output_version_id
• extractor_column_extractor_output_version_id_name_uq (Unique) - extractor_output_version_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
name	text	No	Yes	Column name
referenced_output_id	bigint	Yes	Yes	The output the column refers to. Used when the column is a foreign ID.
referenced_output_row_name	text	No	No	The output row the column refers to. Used when the column is a foreign ID.
data_type_id	bigint	Yes	Yes	Column data type
length	integer	Yes	No	Required value length
min_length	integer	Yes	No	Minimum value length
max_length	integer	Yes	No	Maximum value length
default_value	text	No	No	Default value
header_regex	text	No	No	Regex used to match input header names for auto-mapping
linked_column_name	text	No	No	Used when the same data value should be loaded into multiple tables
extractor_output_version_id	bigint	No	Yes	The output version the column belongs to
created_by	bigint	No	Yes	Snowflake ID of the login that created this column
created_at	timestamp with time zone	No	No	When this column was created