job_exporter_configuration

Configuration for an exporter job, which runs a SQL query and writes the results to a file delivered to a trading partner.

Primary Key:

• job_exporter_configuration_id

Foreign Keys:

• export_trading_partner_sftp_id => trading_partner_sftp.trading_partner_sftp_id
• last_updated_by => login.login_id
• schedule_id => schedule.schedule_id

Indexes:

• job_exporter_configuration_export_trading_partner_sftp_id_idx - export_trading_partner_sftp_id
• job_exporter_configuration_last_updated_by_idx - last_updated_by
• job_exporter_configuration_schedule_id_uq (Unique) - schedule_id

Column	Data Type	Nullable	Indexed	Description
job_exporter_configuration_id	bigint	No	Yes	Snowflake ID for job_exporter_configuration primary key.
name	text	No	No	The name of the exporter job.
schedule_id	bigint	No	Yes	The schedule on which this export runs.
setup_queries	text[]	No	No	Queries that must be run before the query to be exported.
query	text	No	No	SQL query that produces the rows to export.
file_type	file_type	No	No	Output file format.
date_format	exporter_date_format_type	No	No	Format used to render dates included in the output filename.
date_inclusion	date_inclusion_type	No	No	Which dates appear in the output filename: just the start date, just the end date, or both.
date_separator	text	No	No	Separator placed between start and end dates in the filename when date_inclusion is 'both'.
file_prefix	text	No	No	Text prepended to the output filename.
file_suffix	text	No	No	Text appended to the output filename, before the extension.
file_extension	text	No	No	Override for the output file extension. Empty means use the default extension for the configured file_type.
last_updated_by	bigint	No	Yes	login_id of the user who last updated this exporter job.
last_updated_at	timestamp with time zone	No	No	When this exporter job was last updated.
export_folder	text	No	No	Folder name the output file is written to on completion.
export_trading_partner_sftp_id	bigint	Yes	Yes	Optional SFTP destination. Set when the export is delivered to a trading partner via SFTP.
omit_column_names	boolean	No	No	When true, the output file does not start with a row of column names from the query.
header_template	text	No	No	Optional template written as the first line of the output file. Supports {{date}}, {{time}}, and {{datetime}} variables rendered from the export end date.
trailer_template	text	No	No	Optional template written as the last line of the output file. Supports {{date}}, {{time}}, {{datetime}}, and {{rowCount}} variables.
printable_ascii_only	boolean	No	No	When true, characters outside the printable ASCII range are removed from exported field values.
strip_characters	text	No	No	Characters removed from exported field values, e.g. characters a trading partner forbids in data.