How to get the SQL text of the executed SQL Query Node into a variable
I have an SQL query executing as an SQL Script Node in the Master flow. This SQL query is dynamic, as it inserts values like process_id and dynamic database_name, schema_name etc (which are stored as variables in pyramid itself).
After the execution of this query, my purpose is to maintain a status_log table, where I would like to insert the "SQL Query" as a Text format along with its result upon execution and its status as completed or failed, to maintain a log of all the queries that are being executed in my pipeline.
The challenge I am facing is to insert the SQL Query Text in my status_log table.
Kindly suggest solutions to store the SQL query text into a variable, or a way to get the last executed sql query text. Any possible solutions or approaches are appreciated.
Thank You