| agent: |
On5qrCnBeQ2ebOtQXFpKGet All AWS Redshift Clusters
Get All AWS Redshift Clusters
There was a problem that the LLM was not able to address. Please rephrase your prompt and try again.
This process retrieves a list of all Amazon Redshift clusters within an AWS account. Amazon Redshift is a fully managed data warehouse service in the cloud that allows users to run complex analytic queries against petabytes of structured data. By fetching all Redshift clusters, users can gain insights into the number of active clusters, their configurations, statuses, and other related metadata. This information is crucial for administrative tasks, monitoring, and optimizing costs and performance.
inputs
outputs
import boto3
creds = _get_creds(cred_label)['creds']
access_key = creds['username']
secret_key = creds['password']
def get_all_redshift_clusters(region=None):
all_clusters = {}
ec2_client = boto3.client('ec2', aws_access_key_id=access_key, aws_secret_access_key=secret_key, region_name='us-east-1')
regions_to_check = [region] if region else [region['RegionName'] for region in ec2_client.describe_regions()['Regions']]
for region in regions_to_check:
# Initialize the Redshift client for the specified region
redshift = boto3.client('redshift', aws_access_key_id=access_key, aws_secret_access_key=secret_key, region_name=region)
clusters = []
try:
# Using paginator to handle potential pagination of results
paginator = redshift.get_paginator('describe_clusters')
for page in paginator.paginate():
clusters.extend(page['Clusters'])
if clusters: # Check if clusters list is not empty
all_clusters[region] = clusters
except Exception as e:
print(f"Error fetching Redshift clusters in region {region}: {e}")
return all_clusters
# Set region to None for all regions, or specify a valid AWS region string for a specific region
# Example: target_region = 'us-west-1' # Or None for all regions
target_region = None
# Get all Redshift clusters
all_clusters = get_all_redshift_clusters(target_region)
if all_clusters:
print(f"Total Redshift Clusters: {sum(len(clusters) for clusters in all_clusters.values())}")
for region, clusters in all_clusters.items():
print(f"In region {region}:")
for cluster in clusters:
print(f" - {cluster['ClusterIdentifier']}")
else:
print("No Redshift clusters found")
copied