User guide

Database Audit Logging
You can use the database audit logging feature to track information about authentication attempts,
connections, disconnections, changes to database user definitions, and queries run in the database.This
information is useful for security and troubleshooting purposes in Amazon Redshift. The logs are stored
in Amazon S3 buckets. For more information, see Database Audit Logging (p. 215).
Events and Notifications
Amazon Redshift tracks events and retains information about them for a period of several weeks in your
AWS account. For each event, Amazon Redshift reports information such as the date the event occurred,
a description, the event source (for example, a cluster, a parameter group, or a snapshot), and the source
ID.You can create Amazon Redshift event notification subscriptions that specify a set of event filters.
When an event occurs that matches the filter criteria, Amazon Redshift uses Amazon Simple Notification
Service to actively inform you that the event has occurred. For more information about events and
notifications, see Amazon Redshift Events (p. 199).
Performance
Amazon Redshift provides performance metrics and data so that you can track the health and performance
of your clusters and databases. Amazon Redshift uses Amazon CloudWatch metrics to monitor the
physical aspects of the cluster, such as CPU utilization, latency, and throughput. Amazon Redshift also
provides query and load performance data to help you monitor the database activity in your cluster. For
more information about performance metrics and monitoring, see Monitoring Amazon Redshift Cluster
Performance (p. 179).
Databases
Amazon Redshift creates one database when you provision a cluster. This is the database you use to
load data and run queries on your data.You can create additional databases as needed by running a
SQL command. For more information about creating additional databases, go to Step 1: Create a database
in the Amazon Redshift Database Developer Guide.
When you provision a cluster, you specify a master user who has access to all of the databases that are
created within the cluster.This master user is a superuser who is the only user with access to the database
initially, though this user can create additional superusers and users. For more information, go to
Superusers and Users in the Amazon Redshift Database Developer Guide.
Amazon Redshift uses parameter groups to define the behavior of all databases in a cluster, such as
date presentation style and floating-point precision. If you don’t specify a parameter group when you
provision your cluster, Amazon Redshift associates a default parameter group with the cluster. For more
information, see Amazon Redshift Parameter Groups (p. 56).
For more information about databases in Amazon Redshift, go to the Amazon Redshift Database Developer
Guide.
API Version 2012-12-01
4
Amazon Redshift Management Guide
Databases