Clever Geek Handbook

How to log latest Redshift SQL queries with actual parameter values

When I log queries executed on Amazon Redshift by querying a table STL_QUERY

, I receive a prepared statement statement with no parameter values, for example:

SELECT * FROM events WHERE ts=$1

I want to know what are the real values ​​of the parameters.

Is there a way to find out?

+4
amazon-redshift prepared-statement


source to share


No one has answered this question yet

Check out similar questions:

148
How do prepared statements protect against SQL injection attacks?
115
How can I get the SQL PreparedStatement?
110
Using the "like" wildcard in a prepared message
7
Redshift: Executing a dynamic query from a string
6
How to get the value of the $ 1 parameter from a executed prepared statement (inside a trigger using current_query ())
1
Redshift not registering with STL_WLM_RULE_ACTION
1
RedShift NaN in UNION EXCEPT INTERSECT queries
1
Insert redshift values ​​into a table
0
Amazon Redshift Query Without Using the jdbc Driver
0
query killed at redshift


More articles:


All Articles
Loading...
X
Show
Funny
Dev
Pics