job_exporter

Stores exporter related jobs.

Primary Key:

• job_exporter_id

Checks:

• job_etl_status_check - ((status = ANY (ARRAY['succeeded'::claims.job_status_type, 'failed'::claims.job_status_type, 'cancelled'::claims.job_status_type, 'skipped'::claims.job_status_type])) = (job_end IS NOT NULL))

Foreign Keys:

• job_exporter_configuration_id => job_exporter_configuration.job_exporter_configuration_id

Indexes:

• job_exporter_job_exporter_configuration_id_idx - job_exporter_configuration_id

Column	Data Type	Nullable	Indexed	Description
job_exporter_id	bigint	No	Yes	Snowflake ID for the job.
job_exporter_configuration_id	bigint	No	Yes	Foreign key to job_exporter_configuration which tracks details for spawning exporter jobs.
input_start_time	timestamp with time zone	No	No	Start of the time range processed by this run.
input_end_time	timestamp with time zone	No	No	End of the time range processed by this run.
job_start	timestamp with time zone	No	No	Time this attempt started.
job_end	timestamp with time zone	Yes	No	Time this attempt finished. NULL while the attempt is still in progress.
status	job_status_type	No	No	Status of this attempt (e.g. queued, running, succeeded, failed, cancelled, skipped).
job_metadata	jsonb	No	No	Additional metadata describing what the attempt did (e.g. archive_filename, extractor_input_version_id, and anything else useful for understanding what was done and how).
log	text	No	No	Logs captured from this attempt.