# Source: https://docs.datadoghq.com/ddsql_reference/data_directory/aws/aws.redshift_cluster.dataset.md

---
title: Redshift Cluster
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: Docs > DDSQL Reference > Data Directory > Redshift Cluster
---

# Redshift Cluster

An Amazon Redshift Cluster is a fully managed data warehouse that allows you to run complex analytical queries on large datasets. It consists of one or more compute nodes and a leader node that coordinates query execution and data distribution. Redshift clusters are designed for high performance, scalability, and integration with other AWS services, making them suitable for business intelligence, reporting, and big data analytics.

```
aws.redshift_cluster
```

## Fields

| Title                                       | ID   | Type          | Data Type                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Description |
| ------------------------------------------- | ---- | ------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------- |
| _key                                        | core | string        |
| account_id                                  | core | string        |
| allow_version_upgrade                       | core | bool          | A boolean value that, if true, indicates that major version upgrades will be applied automatically to the cluster during the maintenance window.                                                                                                                                                                                                                                                                                                                        |
| aqua_configuration                          | core | json          | This field is retired. Amazon Redshift automatically determines whether to use AQUA (Advanced Query Accelerator).                                                                                                                                                                                                                                                                                                                                                       |
| automated_snapshot_retention_period         | core | int64         | The number of days that automatic cluster snapshots are retained.                                                                                                                                                                                                                                                                                                                                                                                                       |
| availability_zone                           | core | string        | The name of the Availability Zone in which the cluster is located.                                                                                                                                                                                                                                                                                                                                                                                                      |
| availability_zone_relocation_status         | core | string        | Describes the status of the Availability Zone relocation operation.                                                                                                                                                                                                                                                                                                                                                                                                     |
| cluster_availability_status                 | core | string        | The availability status of the cluster for queries. Possible values are the following: Available - The cluster is available for queries. Unavailable - The cluster is not available for queries. Maintenance - The cluster is intermittently available for queries due to maintenance activities. Modifying - The cluster is intermittently available for queries due to changes that modify the cluster. Failed - The cluster failed and is not available for queries. |
| cluster_create_time                         | core | timestamp     | The date and time that the cluster was created.                                                                                                                                                                                                                                                                                                                                                                                                                         |
| cluster_identifier                          | core | string        | The unique identifier of the cluster.                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| cluster_logging                             | core | json          |
| cluster_namespace_arn                       | core | string        | The namespace Amazon Resource Name (ARN) of the cluster.                                                                                                                                                                                                                                                                                                                                                                                                                |
| cluster_nodes                               | core | json          | The nodes in the cluster.                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| cluster_parameter_groups                    | core | json          | The list of cluster parameter groups that are associated with this cluster. Each parameter group in the list is returned with its status.                                                                                                                                                                                                                                                                                                                               |
| cluster_revision_number                     | core | string        | The specific revision number of the database in the cluster.                                                                                                                                                                                                                                                                                                                                                                                                            |
| cluster_security_groups                     | core | json          | A list of cluster security group that are associated with the cluster. Each security group is represented by an element that contains ClusterSecurityGroup.Name and ClusterSecurityGroup.Status subelements. Cluster security groups are used when the cluster is not created in an Amazon Virtual Private Cloud (VPC). Clusters that are created in a VPC use VPC security groups, which are listed by the VpcSecurityGroups parameter.                                |
| cluster_snapshot_copy_status                | core | json          | A value that returns the destination region and retention period that are configured for cross-region snapshot copy.                                                                                                                                                                                                                                                                                                                                                    |
| cluster_status                              | core | string        | The current state of the cluster. Possible values are the following: available available, prep-for-resize available, resize-cleanup cancelling-resize creating deleting final-snapshot hardware-failure incompatible-hsm incompatible-network incompatible-parameters incompatible-restore modifying paused rebooting renaming resizing rotating-keys storage-full updating-hsm                                                                                         |
| cluster_subnet_group_name                   | core | string        | The name of the subnet group that is associated with the cluster. This parameter is valid only when the cluster is in a VPC.                                                                                                                                                                                                                                                                                                                                            |
| cluster_version                             | core | string        | The version ID of the Amazon Redshift engine that is running on the cluster.                                                                                                                                                                                                                                                                                                                                                                                            |
| custom_domain_certificate_arn               | core | string        | The certificate Amazon Resource Name (ARN) for the custom domain name.                                                                                                                                                                                                                                                                                                                                                                                                  |
| custom_domain_certificate_expiry_date       | core | timestamp     | The expiration date for the certificate associated with the custom domain name.                                                                                                                                                                                                                                                                                                                                                                                         |
| custom_domain_name                          | core | string        | The custom domain name associated with the cluster.                                                                                                                                                                                                                                                                                                                                                                                                                     |
| data_transfer_progress                      | core | json          | <p/>                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| db_name                                     | core | string        | The name of the initial database that was created when the cluster was created. This same name is returned for the life of the cluster. If an initial database was not specified, a database named devdev was created by default.                                                                                                                                                                                                                                       |
| default_iam_role_arn                        | core | string        | The Amazon Resource Name (ARN) for the IAM role set as default for the cluster.                                                                                                                                                                                                                                                                                                                                                                                         |
| deferred_maintenance_windows                | core | json          | Describes a group of DeferredMaintenanceWindow objects.                                                                                                                                                                                                                                                                                                                                                                                                                 |
| elastic_ip_status                           | core | json          | The status of the elastic IP (EIP) address.                                                                                                                                                                                                                                                                                                                                                                                                                             |
| elastic_resize_number_of_node_options       | core | string        | The number of nodes that you can resize the cluster to with the elastic resize method.                                                                                                                                                                                                                                                                                                                                                                                  |
| encrypted                                   | core | bool          | A boolean value that, if true, indicates that data in the cluster is encrypted at rest.                                                                                                                                                                                                                                                                                                                                                                                 |
| endpoint                                    | core | json          | The connection endpoint.                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| endpoint_access_list                        | core | json          | The list of endpoints with access to the cluster.                                                                                                                                                                                                                                                                                                                                                                                                                       |
| enhanced_vpc_routing                        | core | bool          | An option that specifies whether to create the cluster with enhanced VPC routing enabled. To create a cluster that uses enhanced VPC routing, the cluster must be in a VPC. For more information, see Enhanced VPC Routing in the Amazon Redshift Cluster Management Guide. If this option is true, enhanced VPC routing is enabled. Default: false                                                                                                                     |
| expected_next_snapshot_schedule_time        | core | timestamp     | The date and time when the next snapshot is expected to be taken for clusters with a valid snapshot schedule and backups enabled.                                                                                                                                                                                                                                                                                                                                       |
| expected_next_snapshot_schedule_time_status | core | string        | The status of next expected snapshot for clusters having a valid snapshot schedule and backups enabled. Possible values are the following: OnTrack - The next snapshot is expected to be taken on time. Pending - The next snapshot is pending to be taken.                                                                                                                                                                                                             |
| hsm_status                                  | core | json          | A value that reports whether the Amazon Redshift cluster has finished applying any hardware security module (HSM) settings changes specified in a modify cluster command. Values: active, applying                                                                                                                                                                                                                                                                      |
| iam_roles                                   | core | json          | A list of Identity and Access Management (IAM) roles that can be used by the cluster to access other Amazon Web Services services.                                                                                                                                                                                                                                                                                                                                      |
| ip_address_type                             | core | string        | The IP address type for the cluster. Possible values are ipv4 and dualstack.                                                                                                                                                                                                                                                                                                                                                                                            |
| kms_key_id                                  | core | string        | The Key Management Service (KMS) key ID of the encryption key used to encrypt data in the cluster.                                                                                                                                                                                                                                                                                                                                                                      |
| maintenance_track_name                      | core | string        | The name of the maintenance track for the cluster.                                                                                                                                                                                                                                                                                                                                                                                                                      |
| manual_snapshot_retention_period            | core | int64         | The default number of days to retain a manual snapshot. If the value is -1, the snapshot is retained indefinitely. This setting doesn't change the retention period of existing snapshots. The value must be either -1 or an integer between 1 and 3,653.                                                                                                                                                                                                               |
| master_password_secret_arn                  | core | string        | The Amazon Resource Name (ARN) for the cluster's admin user credentials secret.                                                                                                                                                                                                                                                                                                                                                                                         |
| master_password_secret_kms_key_id           | core | string        | The ID of the Key Management Service (KMS) key used to encrypt and store the cluster's admin credentials secret.                                                                                                                                                                                                                                                                                                                                                        |
| master_username                             | core | string        | The admin user name for the cluster. This name is used to connect to the database that is specified in the DBName parameter.                                                                                                                                                                                                                                                                                                                                            |
| modify_status                               | core | string        | The status of a modify operation, if any, initiated for the cluster.                                                                                                                                                                                                                                                                                                                                                                                                    |
| multi_az                                    | core | string        | A boolean value that, if true, indicates that the cluster is deployed in two Availability Zones.                                                                                                                                                                                                                                                                                                                                                                        |
| multi_az_secondary                          | core | json          | The secondary compute unit of a cluster, if Multi-AZ deployment is turned on.                                                                                                                                                                                                                                                                                                                                                                                           |
| next_maintenance_window_start_time          | core | timestamp     | The date and time in UTC when system maintenance can begin.                                                                                                                                                                                                                                                                                                                                                                                                             |
| node_type                                   | core | string        | The node type for the nodes in the cluster.                                                                                                                                                                                                                                                                                                                                                                                                                             |
| number_of_nodes                             | core | int64         | The number of compute nodes in the cluster.                                                                                                                                                                                                                                                                                                                                                                                                                             |
| parameters                                  | core | json          | A list of Parameter instances. Each instance lists the parameters of one cluster parameter group.                                                                                                                                                                                                                                                                                                                                                                       |
| pending_actions                             | core | array<string> | Cluster operations that are waiting to be started.                                                                                                                                                                                                                                                                                                                                                                                                                      |
| pending_modified_values                     | core | json          | A value that, if present, indicates that changes to the cluster are pending. Specific pending changes are identified by subelements.                                                                                                                                                                                                                                                                                                                                    |
| preferred_maintenance_window                | core | string        | The weekly time range, in Universal Coordinated Time (UTC), during which system maintenance can occur.                                                                                                                                                                                                                                                                                                                                                                  |
| publicly_accessible                         | core | bool          | A boolean value that, if true, indicates that the cluster can be accessed from a public network. Default: false                                                                                                                                                                                                                                                                                                                                                         |
| redshift_cluster_arn                        | core | string        |
| reserved_node_exchange_status               | core | json          | The status of the reserved-node exchange request. Statuses include in-progress and requested.                                                                                                                                                                                                                                                                                                                                                                           |
| resize_info                                 | core | json          | Returns the following: AllowCancelResize: a boolean value indicating if the resize operation can be cancelled. ResizeType: Returns ClassicResize                                                                                                                                                                                                                                                                                                                        |
| restore_status                              | core | json          | A value that describes the status of a cluster restore action. This parameter returns null if the cluster was not created by restoring a snapshot.                                                                                                                                                                                                                                                                                                                      |
| snapshot_schedule_identifier                | core | string        | A unique identifier for the cluster snapshot schedule.                                                                                                                                                                                                                                                                                                                                                                                                                  |
| snapshot_schedule_state                     | core | string        | The current state of the cluster snapshot schedule.                                                                                                                                                                                                                                                                                                                                                                                                                     |
| tags                                        | core | hstore_csv    |
| total_storage_capacity_in_mega_bytes        | core | int64         | The total storage capacity of the cluster in megabytes.                                                                                                                                                                                                                                                                                                                                                                                                                 |
| vpc_id                                      | core | string        | The identifier of the VPC the cluster is in, if the cluster is in a VPC.                                                                                                                                                                                                                                                                                                                                                                                                |
| vpc_security_groups                         | core | json          | A list of Amazon Virtual Private Cloud (Amazon VPC) security groups that are associated with the cluster. This parameter is returned only if the cluster is in a VPC.                                                                                                                                                                                                                                                                                                   |