ingestion_run

18 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_id, operator_id, target_table, status, rows_inserted, rows_updated, rows_skipped, started_at (date), ended_at (date)

CREATE TABLE ingestion_run (
	run_id INTEGER NOT NULL, 
	source_id INTEGER NOT NULL, 
	operator_id INTEGER NOT NULL, 
	target_table VARCHAR(64), 
	status VARCHAR(7) NOT NULL, 
	raw_file_path VARCHAR(1024), 
	api_endpoint VARCHAR(1024), 
	checksum_md5 VARCHAR(32), 
	rows_inserted INTEGER NOT NULL, 
	rows_updated INTEGER NOT NULL, 
	rows_skipped INTEGER NOT NULL, 
	rows_failed INTEGER NOT NULL, 
	started_at DATETIME NOT NULL, 
	ended_at DATETIME, 
	duration_ms INTEGER, 
	extra JSON, 
	PRIMARY KEY (run_id), 
	FOREIGN KEY(source_id) REFERENCES data_source (source_id), 
	FOREIGN KEY(operator_id) REFERENCES operator (operator_id)
);
CREATE INDEX ix_ingestion_run_source_id ON ingestion_run (source_id);
CREATE INDEX ix_ingestion_run_operator_id ON ingestion_run (operator_id);