AWS Redshift - SQS - SSO Tables

AWS Redshift Tables

AWSRedshiftClusterDeferredMaintenanceWindows

Stores deferred maintenance windows configured for Amazon Redshift clusters, including window identifiers and scheduled start and end times.

Name	Type	Description
ConfigID	integer	Unique identifier of the configuration associated with this deferred maintenance window record.
ID	integer	Auto-incremented primary key for the deferred maintenance window row.
DeferMaintenanceIdentifier	string	Unique identifier of the deferred maintenance window.
DeferMaintenanceStartTime	datetime	Timestamp when the deferred maintenance window starts.
DeferMaintenanceEndTime	datetime	Timestamp when the deferred maintenance window ends.
AWSRedshiftClusterID	string	Identifier of the Redshift cluster to which this deferred maintenance window belongs.
BatchDate	datetime	Timestamp when this record was ingested during the batch processing run.

AWSRedshiftClusterIAMRoles

Records IAM roles associated with Amazon Redshift clusters, along with their apply status.

Name	Type	Description
ConfigID	integer	Unique identifier of the configuration associated with this IAM role record.
ID	integer	Auto-incremented primary key for the Redshift cluster IAM role row.
IAMRoleARN	string	ARN of the IAM role associated with the Redshift cluster.
ApplyStatus	string	Status of the IAM role association with the cluster (e.g., `in-sync`, `adding`, `removing`).
AWSRedshiftClusterID	string	Identifier of the Redshift cluster to which this IAM role is associated.
BatchDate	datetime	Timestamp when this record was ingested during the batch processing run.

AWSRedshiftClusterNodes

Contains node-level details for Amazon Redshift clusters, including node role, IP addresses, and secondary node designation.

Name	Type	Description
ConfigID	integer	Unique identifier of the configuration associated with this cluster node record.
ID	integer	Auto-incremented primary key for the Redshift cluster node row.
NodeRole	string	Role of the node within the cluster (e.g., `LEADER`, `COMPUTE`, `SHARED`).
PrivateIPAddress	string	Private IPv4 address of the Redshift cluster node.
PublicIPAddress	string	Public IPv4 address of the Redshift cluster node, if publicly accessible.
IsSecondary	boolean	Indicates whether this node is a secondary (standby) node in a multi-AZ deployment.
AWSRedshiftClusterID	string	Identifier of the Redshift cluster to which this node belongs.
BatchDate	datetime	Timestamp when this record was ingested during the batch processing run.

AWSRedshiftClusterParameterGroups

Stores parameter group associations for Amazon Redshift clusters, including group name, apply status, and individual parameter statuses.

Name	Type	Description
ConfigID	integer	Unique identifier of the configuration associated with this parameter group record.
ID	integer	Auto-incremented primary key for the Redshift cluster parameter group row.
ParameterGroupName	string	Name of the Redshift parameter group associated with the cluster.
ParameterApplyStatus	string	Apply status of the parameter group to the cluster (e.g., `in-sync`, `pending-reboot`).
ClusterParameterStatusListSerialized	string	Serialized list of individual parameter statuses within the parameter group.
AWSRedshiftClusterID	string	Identifier of the Redshift cluster to which this parameter group is associated.
BatchDate	datetime	Timestamp when this record was ingested during the batch processing run.

AWSRedshiftClusters

Comprehensive table of Amazon Redshift cluster configurations, including compute, storage, encryption, networking, snapshot, maintenance, and pending change details.

Name	Type	Description
ConfigID	integer	Unique identifier of the configuration associated with this Redshift cluster record.
ClusterID	string	User-defined identifier of the Redshift cluster (e.g., `my-redshift-cluster`).
NodeType	string	Node type of the Redshift cluster (e.g., `dc2.large`, `ra3.xlplus`).
ClusterStatus	string	Current operational status of the cluster (e.g., `available`, `creating`, `deleting`).
MasterUsername	string	Username of the master database user for the Redshift cluster.
DBName	string	Name of the default database created when the Redshift cluster was provisioned.
NumberOfNodes	integer	Number of compute nodes in the Redshift cluster.
Encrypted	boolean	Indicates whether the Redshift cluster's data is encrypted at rest.
KmsKeyID	string	ID of the KMS key used to encrypt the Redshift cluster's data.
VpcID	string	ID of the VPC in which the Redshift cluster is deployed.
AvailabilityZone	string	Availability zone where the Redshift cluster is located (e.g., `us-east-1a`).
AvailabilityZoneRelocationStatus	string	Status of an availability zone relocation operation for the cluster.

AWSRedshiftClusterSecurityGroups

Records EC2-Classic security group associations for Amazon Redshift clusters and their membership status.

Name	Type	Description
ConfigID	integer	Unique identifier of the configuration associated with this security group record.
ID	integer	Auto-incremented primary key for the Redshift cluster security group row.
ClusterSecurityGroupName	string	Name of the EC2-Classic security group associated with the Redshift cluster.
Status	string	Status of the security group association with the cluster (e.g., `active`, `adding`, `revoking`).
AWSRedshiftClusterID	string	Identifier of the Redshift cluster to which this security group is associated.
BatchDate	datetime	Timestamp when this record was ingested during the batch processing run.

AWSRedshiftClusterVpcSecurityGroups

Stores VPC security group associations for Amazon Redshift clusters and their current membership status.

Name	Type	Description
ConfigID	integer	Unique identifier of the configuration associated with this VPC security group record.
ID	integer	Auto-incremented primary key for the Redshift cluster VPC security group row.
VpcSecurityGroupID	string	ID of the VPC security group associated with the Redshift cluster (e.g., `sg-0abc123456789def0`).
Status	string	Status of the VPC security group association with the cluster (e.g., `active`, `adding`).
AWSRedshiftClusterID	string	Identifier of the Redshift cluster to which this VPC security group is associated.
BatchDate	datetime	Timestamp when this record was ingested during the batch processing run.

AWS SQS Table

AWSSQSQueues

Contains configuration and operational attributes of Amazon SQS queues, including retention policies, encryption settings, throughput limits, and access policies.

Name	Type	Description
ConfigID	integer	Unique identifier of the configuration associated with this SQS queue record.
QueueARN	string	Full ARN of the SQS queue.
QueueURL	string	URL of the SQS queue, used to send and receive messages.
QueueName	string	Name of the SQS queue.
CreatedTimestamp	datetime	Timestamp when the SQS queue was created.
LastModifiedTimestamp	datetime	Timestamp when the SQS queue attributes were last modified.
ApproximateNumberOfMessages	bigint	Approximate number of messages available for retrieval from the queue.
ApproximateNumberOfMessagesNotVisible	bigint	Approximate number of messages currently in flight (received but not deleted).
ApproximateNumberOfMessagesDelayed	bigint	Approximate number of messages delayed and not yet available for retrieval.
VisibilityTimeout	integer	Duration in seconds that a received message is hidden from subsequent retrieve requests.
MaximumMessageSize	integer	Maximum size in bytes of a message that can be sent to the queue.
MessageRetentionPeriod	integer	Number of seconds SQS retains a message if it is not deleted (range: 60-1209600 seconds).

AWS SSO Tables

AWSSSOAccountAssignments

Records IAM Identity Center account assignments, mapping permission sets to AWS accounts and specific users or groups.

Name	Type	Description
ConfigID	integer	Unique identifier of the configuration associated with this SSO account assignment record.
ID	integer	Auto-incremented primary key for the SSO account assignment row.
AccountID	string	AWS account ID to which the permission set is assigned.
AWSSSOPermissionSetARN	string	ARN of the IAM Identity Center permission set assigned to the account.
PrincipalType	string	Type of principal assigned to the account (e.g., `USER`, `GROUP`).
PrincipalID	string	Unique identifier of the user or group assigned to the account.
BatchDate	datetime	Timestamp when this record was ingested during the batch processing run.

AWSSSOInstances

Stores metadata for IAM Identity Center (SSO) instances, including associated identity store, owner account, and instance status.

Name	Type	Description
ConfigID	integer	Unique identifier of the configuration associated with this SSO instance record.
InstanceARN	string	ARN of the IAM Identity Center instance.
IdentityStoreID	string	ID of the identity store associated with the IAM Identity Center instance.
Name	string	Friendly name of the IAM Identity Center instance.
OwnerAccountID	string	AWS account ID that owns and manages this IAM Identity Center instance.
Status	string	Current status of the IAM Identity Center instance (e.g., `ACTIVE`, `CREATE_IN_PROGRESS`).
CreatedDate	datetime	Timestamp when the IAM Identity Center instance was created.
BatchDate	datetime	Timestamp when this record was ingested during the batch processing run.

AWSSSOPermissionSets

Contains IAM Identity Center permission sets with their session duration, relay state, and associated SSO instance.

Name	Type	Description
ConfigID	integer	Unique identifier of the configuration associated with this permission set record.
PermissionSetARN	string	ARN of the IAM Identity Center permission set.
Name	string	Name of the permission set.
Description	string	Description of the permission set and its intended access scope.
SessionDuration	string	Maximum duration of a user session for this permission set (ISO 8601 format, e.g., `PT8H`).
RelayState	string	URL to redirect users to after they authenticate via IAM Identity Center.
CreatedDate	datetime	Timestamp when the permission set was created.
AWSSSOInstanceARN	string	ARN of the IAM Identity Center instance to which this permission set belongs.
BatchDate	datetime	Timestamp when this record was ingested during the batch processing run.