Redshift Observatory

System Table Tracker

System view pg_auto_copy.copy_job_detail version 1.0.76913 / 2024-10-24

schema	name	column	data type
pg_auto_copy	copy_job_detail	enqueue_time	timestamp
pg_auto_copy	copy_job_detail	file_etag	varchar(512)
pg_auto_copy	copy_job_detail	file_location	varchar(256)
pg_auto_copy	copy_job_detail	file_name	varchar(2048)
pg_auto_copy	copy_job_detail	file_size	int8
pg_auto_copy	copy_job_detail	generation	int4
pg_auto_copy	copy_job_detail	ingestion_status	int2
pg_auto_copy	copy_job_detail	job_id	int8
pg_auto_copy	copy_job_detail	job_name	varchar(256)
pg_auto_copy	copy_job_detail	job_owner	int8
pg_auto_copy	copy_job_detail	modification_time	timestamp
pg_auto_copy	copy_job_detail	xid	int8

View Text

SELECT CAST(0 AS bigint) AS job_owner,
       CAST(0 AS bigint) AS job_id,
       CAST(CAST('' AS varchar) AS varchar(256)) AS job_name,
       0 AS generation,
       CAST(0 AS bigint) AS xid,
       CAST(CAST('' AS varchar) AS varchar(256)) AS file_location,
       CAST(CAST('' AS varchar) AS varchar(2048)) AS file_name,
       CAST(0 AS bigint) AS file_size,
       CAST(CAST('' AS varchar) AS varchar(512)) AS file_etag,
       CAST(NULL AS timestamp) AS modification_time,
       CAST(NULL AS timestamp) AS enqueue_time,
       CAST(0 AS smallint) AS ingestion_status
LIMIT 0

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers