setting enable_user_activity_logging parameter to true in Redshift

By default if you enable audit logging to S3 for AWS Redshift clusters , it will not log user activities. Its because user_activity_logging parameter is disable at cluster level. You need to create custom parameter group from workload management tab and set enable_user_activity_logging to True.

You can user following steps to set enable_user_activity_logging parameter to true

Step 1 : Create custom parameter group

Step 2 : Set enable_user_activity_logging to true.

Step 3 : Reboot the cluster