awslabs / athena-glue-service-logs

Glue scripts for converting AWS Service Logs for use in Athena
Apache License 2.0
142 stars 46 forks source link

Add Redshift audit logs processing. #7

Open BigDataDaddy opened 5 years ago

BigDataDaddy commented 5 years ago

Another AWS log format that would be very useful to process with a Glue Job and query with Athena (or Redshift Spectrum) is Redshift audit logs, specifically the user log, user activity log, and connection log file formats created in S3 by the feature. See here for the Redshift feature that creates these logs.

DBZshahin commented 5 years ago

Is there any plan to rollout AWS Audit logs in Athena/ Spectrum readable formats. At preset, there is no way we can create an external table on logs files. Any alternate approach available ?