svl_stored_proc_messages not accessible in AWS Redshift Serverless

0

Hi, I was using the svl_stored_proc_messages object in RA3 provisioned cluster environment. We recently moved to server less environment. But this object is not accessible and giving the following error. But I am using super user. ERROR: permission denied for relation svl_stored_proc_messages [ErrorId: 1-65a63f47-7e0368ac06da55740f07baa0] is any one facing same issue or any limitations on server less cluster. I don't see any such limitations in documentation.

https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_STORED_PROC_MESSAGES.html

Appreciate any thoughts here please. Thanks.

Raj
asked 2 months ago98 views
1 Answer
0
Accepted Answer

For Redshift Serverless, you should use https://docs.aws.amazon.com/redshift/latest/dg/SYS_PROCEDURE_MESSAGES.html

Please refer this page for mapping between provisioned cluster views and Redshift serverless views. https://docs.aws.amazon.com/redshift/latest/dg/sys_view_migration.html

AWS
EXPERT
answered 2 months ago
  • Thanks Satesh. It greatly helped.

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