job_http

Tracks the runs of jobs that send requests to an http endpoint.

Primary Key:

• job_http_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_http_configuration_id => job_http_configuration.job_http_configuration_id

Indexes:

• job_http_job_http_configuration_id_idx - job_http_configuration_id

Column	Data Type	Nullable	Indexed	Description
job_http_id	bigint	No	Yes	Snowflake ID for job_http primary key.
job_http_configuration_id	bigint	No	Yes	Foreign key to job_http_configuration which tracks details for spawning http jobs.
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.