script to check failed logins in aws redshift database?

 script to check  failed logins in aws redshift database

SELECT *

FROM stl_connection_log

WHERE event='authentication failure'

ORDER BY recordtime;