Ensure that user activity logging is enabled for your Amazon Redshift clusters.
Redshift clusters associated parameter groups should have user activity logging enabled in order to log user activities performed.
Update Redshift parameter groups to enable user activity logging