View a markdown version of this page

SYS_COPY_JOB_INFO - Amazon Redshift
Table columns
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the blog post that was published on June 30, 2025.

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.