How to Query the Stored Procedure Transaction Mode in Redshift

0

Is there a way to query the tranaction mode of a stored procedure in Redshift? What I mean is, if I created an SP in NONATOMIC mode, is there anywhere within Redshift system table to let me know that this procedure is NONATOMIC rather than in the default ATOMIC mode?

AWS
Lei
已提問 7 個月前檢視次數 239 次
1 個回答
0
已接受的答案

Firstly to answer your question , currently there is no system table that you can query to obtain this information.

Secondly, would be interesting to know the persona to better understand your use case.

In my opinion there are only 2 main personas for stored procedures...

  1. A developer who know exactly if the procedure is atomic or nonatomic. The developer will choose one or other to meet the business requirements that were provided to code the procedure. you should have access to the code repo to review other procedures if you are expected to nest them.
  2. An executor who shouldn’t really need to know if the procedure is atomic or nonatomic. The user calls the procedure and it delivers what it was supposed to deliver.
profile pictureAWS
已回答 7 個月前
profile picture
專家
已審閱 1 個月前
  • I got asked this question by my customer, who I believe is the developer of the SP. The reason for he getting this question is unclear. If you let me guess, it might be the cause that the developer happened to forgot whether he/she put this SP as ATOMIC or NONATOMIC, so he wished a way to get this info from query, if there could be a one.

  • No system table-column that exposes this, but the developer can execute SHOW PROCEDURE to review the code OR look into their code repository.

  • I found out from PM's that this is potentially a 2024Q1 item :-) so be on the look out.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南