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
質問済み 4ヶ月前204ビュー
1回答
0
承認された回答

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
エキスパート
回答済み 4ヶ月前
  • Thanks Satesh. It greatly helped.

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ