Error fetching sample data: (psycopg2.OperationalError) could not translate host name "postgresql.postgresql" to address: Name or service not known (Background on this error at: https://sqlalche.me/e/20/e3q8)

FileIngestion

Run Query

Table Name: file_ingestions

Columns

Name	Type	Nullable	Primary Key	Default
`id`	`UUID`	False	Yes	CallableColumnDefault(<function uuid4 at 0x74d1eb9c0cc0>)
`source`	`VARCHAR(255)`	False	No	None
`effective_date`	`DATE`	False	No	None
`filename`	`VARCHAR(255)`	False	No	None
`uploaded_at`	`DATETIME`	False	No	None
`updated_at`	`DATETIME`	True	No	None
`status`	`VARCHAR(10)`	False	No	ScalarElementColumnDefault('PENDING')
`checksum`	`VARCHAR(64)`	False	No	None
`file_data`	`BLOB`	True	No	None
`target_model`	`VARCHAR(255)`	True	No	None
`metadata`	`JSONB`	True	No	None
`upload_session_id`	`UUID`	True	No	None
`load_type`	`VARCHAR(50)`	True	No	None
`version`	`INTEGER`	True	No	ScalarElementColumnDefault(1)
`cycle_id`	`INTEGER`	True	No	None
`config_id`	`INTEGER`	True	No	None
`trigger_type`	`VARCHAR(50)`	True	No	None
`is_active`	`BOOLEAN`	False	No	ScalarElementColumnDefault(True)
`replaced_by`	`UUID`	True	No	None
`nullified_at`	`DATETIME`	True	No	None
`nullified_by`	`VARCHAR(100)`	True	No	None
`nullification_reason`	`TEXT`	True	No	None
`min_effective_date`	`DATE`	True	No	None
`max_effective_date`	`DATE`	True	No	None
`record_count`	`INTEGER`	True	No	None
`finalized_at`	`DATETIME`	True	No	None
`finalized_by`	`VARCHAR(128)`	True	No	None
`can_modify`	`BOOLEAN`	True	No	ScalarElementColumnDefault(True)

Data Filters

Active Filters:

Data Records

id	source	effective_date	filename	uploaded_at	updated_at	status	checksum	file_data	target_model	metadata	upload_session_id	load_type	version	cycle_id	config_id	trigger_type	is_active	replaced_by	nullified_at	nullified_by	nullification_reason	min_effective_date	max_effective_date	record_count	finalized_at	finalized_by	can_modify

Showing 1-0 of 0

Relationships

Relationship Name	Target Model	Direction
`pipeline_stages`	ingestion_pipeline_stages	ONETOMANY
`cycle`	ingestion_cycle_record	MANYTOONE
`config`	master_ingestion_config	MANYTOONE
`file_logs`	ingestion_file_log	ONETOMANY
`error_logs`	file_ingestion_errors	ONETOMANY
`upload_session`	ingestion_upload_sessions	MANYTOONE
`cycle_expectation`	cycle_expected_files	ONETOMANY
`change_logs`	ingestion_change_logs	ONETOMANY
`snapshots`	ingestion_snapshots	ONETOMANY
`lifecycle_records`	ingestion_lifecycle_status	ONETOMANY
`events`	ingestion_events	ONETOMANY
`ingestion_status`	ingestion_status	ONETOMANY