extractor_input

Stores extractor input configuration information

Primary Key:

• extractor_input_id

Foreign Keys:

• extractor_wizard_id => extractor_wizard.extractor_wizard_id

Indexes:

• extractor_input_extractor_wizard_id_idx - extractor_wizard_id

Column	Data Type	Nullable	Indexed	Description
extractor_input_id	bigint	No	Yes	Snowflake ID for the extractor input Generated through expression:
input_type	extractor_input_type	No	No	Input type (csv, xlsx, zip, fixedWidth, or table) Generated through expression:
extractor_wizard_id	bigint	No	Yes	Wizard to use for the input Generated through expression:
output_path	text	No	No	Path for the output ZIP Generated through expression:
zip_name	text	No	No	Name of the ZIP archive containing extractor outputs Generated through expression:
has_header	boolean	No	No	Whether the source file contains a header row Generated through expression:
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. Generated through expression:
skip_lines_start	integer	No	No	Number of lines to skip at the beginning of the file Generated through expression:
skip_lines_end	integer	No	No	Number of lines to skip at the end of the file Generated through expression:
multi_line_header_start_regex	text	No	No	Regex marking the first line of a multi-line header block Generated through expression:
multi_line_header_end_regex	text	No	No	Regex marking the final line of a multi-line header block Generated through expression:
csv_option_continue_on_error	boolean	No	No	Whether to continue scanning after parse errors instead of stopping Generated through expression:
csv_option_comma	integer	No	No	Unicode code point for the field delimiter (default 44 = ',') Generated through expression:
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. Generated through expression:
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. Generated through expression:
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 Generated through expression:
csv_option_reuse_record	boolean	No	No	Whether to reuse backing arrays for performance when scanning Generated through expression:
csv_option_trim_leading_space	boolean	No	No	Whether leading whitespace in fields is ignored Generated through expression:
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. Generated through expression: