By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Redshift Serverless Copy Feature to load data from S3

0

How can we check the logs of the copy feature while loading the data from S3 to Redshift serverless? AWS has not given access to STL_LOAD_ERRORS table for serverless because of this I am not able to check which files are loaded and which are not?

In addition to that, I also wanted to check whether Redshift serverless will allow the Auto-copy feature in production. As per the latest preview, the auto-copy is only available for provisioned clusters.

Topics
ServerlessAnalytics
Tags
ServerlessAmazon Redshift
Language
English
shubu2212
asked 10 months ago587 views
2 Answers
1

Hello, For redshift serverless, you may check SYS_LOAD_HISTORY[1] to view details of COPY commands. Each row represents a COPY command with accumulated statistics for some of the fields. It contains both running and finished COPY commands To view details of COPY command errors, you may refer to SYS_LOAD_ERROR_DETAIL[2] system view.

Redshift auto-copy feature is currently available as a preview for provisioned clusters only and not for serverless. However, this feature might be available in Serverless on GA

Reference Links: [1] SYS_LOAD_HISTORY: https://docs.aws.amazon.com/redshift/latest/dg/SYS_LOAD_HISTORY.html [2] SYS_LOAD_ERROR_DETAIL: https://docs.aws.amazon.com/redshift/latest/dg/SYS_LOAD_ERROR_DETAIL.html

AWS
SUPPORT ENGINEER
rePost-User-0920359
answered 10 months ago
0

In serverless, the please refer to SYS_LOAD_ERROR_DETAIL. It provides details on COPY command errors.

AWS Support or your AWS account team are best suited to answer your second question. Please create a support case to get it answered

AWS
Anusha_C
answered 10 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content