extractor_input_version

Versioned extractor input

Primary Key:

• extractor_input_version_id

Foreign Keys:

• created_by => login.login_id
• extractor_wizard_version_id => extractor_wizard_version.extractor_wizard_version_id
• extractor_input_id => extractor_input.extractor_input_id

Indexes:

• extractor_input_version_created_by_idx - created_by
• extractor_input_version_extractor_input_id_idx - extractor_input_id
• extractor_input_version_extractor_wizard_version_id_idx - extractor_wizard_version_id

Column	Data Type	Nullable	Indexed	Description
extractor_input_version_id	bigint	No	Yes	Snowflake ID for this version
extractor_input_id	bigint	No	Yes	Link to the input identity row
extractor_wizard_version_id	bigint	No	Yes	Link to the wizard version to use for this input version
input_type	extractor_input_type	No	No	Input type (csv, xlsx, zip, fixedWidth, or table)
output_path	text	No	No	Path for the output ZIP
zip_name	text	No	No	Name of the ZIP archive containing extractor outputs
has_header	boolean	No	No	Whether the source file contains a header row
null_values	text[]	No	No	Values in the source data that can indicate that the data is actually NULL. For example, a date of 1/1/1900 may be used in some systems as a default date and indicates that the data is NULL. extractor will replace all null_values encountered with NULL in the database.
skip_lines_start	integer	No	No	Number of lines to skip at the beginning of the file
skip_lines_end	integer	No	No	Number of lines to skip at the end of the file
multi_line_header_start_regex	text	No	No	Regex marking the first line of a multi-line header block
multi_line_header_end_regex	text	No	No	Regex marking the final line of a multi-line header block
csv_option_continue_on_error	boolean	No	No	Whether to continue scanning after parse errors instead of stopping
csv_option_comma	integer	No	No	Unicode code point for the field delimiter (default 0 = ',')
csv_option_comment	integer	No	No	Unicode code point for the comment character (default 0 = disabled). Lines beginning with the comment character without preceding whitespace are ignored.
csv_option_fields_per_record	integer	Yes	No	If fields_per_record is positive, extractor will require each record to have exactly that number of fields. If it is set to 0 (default behavior), the reader automatically sets it to the number of fields in the first record, enforcing that all subsequent records must have the same count. If fields_per_record is negative, no field count validation is performed, allowing records to have a variable number of fields, which is useful for handling irregular CSV files.
csv_option_lazy_quotes	boolean	No	No	Whether to allow quotes to appear in unquoted fields and non-double quotes to appear in quoted fields
csv_option_reuse_record	boolean	No	No	Whether to reuse backing arrays for performance when scanning
csv_option_trim_leading_space	boolean	No	No	Whether leading whitespace in fields is ignored
csv_option_ignore_quotes	boolean	No	No	Whether to ignore quotes and split fields naively at the delimiter. This can be useful for files with unescaped double quotes in one or more columns. By default, these quotes are treated as escape characters and the file will likely error or return incorrect results.
created_by	bigint	No	Yes	Snowflake ID of the login that created this version
created_at	timestamp with time zone	No	No	When this version was created