Redshift serverless: Autocopy jobs not displayed in web UI

This is indeed unexpected behavior from a user's perspective, but it is currently a known limitation of the AWS Management Console, specifically for Redshift Serverless. The "S3 event integrations" page in the Web UI was primarily designed to manage integrations for provisioned Redshift clusters and has not yet been fully updated to display the associated auto-copy jobs when the target is a Serverless namespace. Your observation is correct: while the underlying integration and the copy job are functioning perfectly, the console simply lacks the capability to list or manage these jobs for the Serverless environment.

The correct and officially supported way to monitor and manage your auto-copy jobs in Redshift Serverless is exactly as you've discovered: by using SQL commands directly within your namespace. The sys_copy_job view is the source of truth for viewing job status, configurations, and history. Similarly, any management tasks must be performed programmatically via SQL.

*For managing these jobs moving forward, you should rely on the following: * Viewing Jobs: Continue using

SELECT * FROM sys_copy_job;

to see all defined jobs and their status. Monitoring Errors: Check SELECT * FROM stl_load_errors; or query the sys_load_error_detail view to diagnose any files that fail to copy. Altering or Dropping Jobs: Use the SQL commands ALTER COPY JOB ... and DROP COPY JOB ... to make changes or remove a job. In short, your setup is correct, and the jobs are not at risk. The discrepancy is purely a gap in the current UI functionality for Redshift Serverless, and for now, you must rely on SQL queries for all management and monitoring tasks related to the jobs themselves.