#My log activity update
#My log activity archive

STL_CONNECTION_LOG: Logs authentication attempts, connections, or disconnections.Combines all of the rows in the STL_DDLTEXT, STL_QUERYTEXT, and STL_UTILITYTEXT tables. SVL_STATEMENTTEXT: Provides a complete record of SQL commands that have been run on the system.

Use the following tables to review information similar to what is stored in the S3 audit logs: For more information, see Enabling logging. User activity log Note: You must enable the enable_user_activity_logging database parameter for the user activity log.Stores information in the following log files: It's not always possible to correlate process IDs with database activities, because process IDs might be recycled when the cluster restarts.

Cluster restarts don't affect audit logs in Amazon S3. Using timestamps, you can correlate process IDs with database activities. Running queries against STL tables requires database computing resources, just as when you run other queries. Reviewing logs stored in Amazon S3 doesn't require database computing resources. To extend the retention period, use the Amazon Redshift system object persistence utility from AWS Labs on GitHub.Īccess to audit log files doesn't require access to the Amazon Redshift database.Īccess to STL tables requires access to the Amazon Redshift database. Log history is stored for two to five days, depending on log usage and available disk space. For more information, see Object lifecycle management.

#My log activity archive

To enable audit logging, follow the steps for Configuring auditing using the console or Configuring logging by using the Amazon Redshift CLI and API.Īutomatically available on every node in the data warehouse cluster.Īudit log files are stored indefinitely unless you define Amazon S3 lifecycle rules to archive or delete files automatically. Choose the logging option that's appropriate for your use case. The following table compares audit logs and STL tables. For more information, see Analyze database audit logs for security and compliance using Amazon Redshift Spectrum. Note: To view logs using external tables, use Amazon Redshift Spectrum. CloudTrail tracks activities performed at the service level. These tables also record the SQL activities that these users performed and when. AWS CloudTrail: Stored in Amazon S3 bucketsĪudit logs and STL tables record database-level activities, such as which users logged in and when.STL tables: Stored on every node in the cluster.Audit logs: Stored in Amazon Simple Storage Service (Amazon S3) buckets.

#My log activity update

Friend Activity not updating?įriend Activity might not update in real time.Amazon Redshift provides three logging options: Tip: To see who’s following you, click your name in the top-right corner of the app and click FOLLOWERS. If you don’t want to share your listening activity with your followers on their Friend Activity tab, you can disable it following the steps below. How do I turn off my listening activity showing on my followers’ Friend Activity? It might be hidden if the size of the window is too small. Note: Friend Activity tab is on the right side of your desktop app.

Under Display, switch See what your friends are playing on, or off.

Click your profile picture at the top, and select Settings.

Friend Activity shows you what your friends are playing.