SYS_COPY_JOB_INFO - Amazon Redshift

SYS_COPY_JOB_INFO

Use SYS_COPY_JOB_INFO to view messages logged about a COPY JOB.

This view contains information about errors in a COPY JOB that has run.

SYS_COPY_JOB_INFO is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.

Table columns

Column name Data type Description
job_id bigint The copy job identifier.
job_name character(128) The name of the copy job.
database_name character(128) The name of the database.
record_time timestamp The time (UTC) when the message was logged.
message chaacter(512) This message of the logged event for a COPY JOB.