steampipe plugin install awssteampipe plugin install aws
aws_accessanalyzer_analyzeraws_accountaws_acm_certificateaws_api_gateway_api_keyaws_api_gateway_authorizeraws_api_gateway_rest_apiaws_api_gateway_stageaws_api_gateway_usage_planaws_api_gatewayv2_apiaws_api_gatewayv2_domain_nameaws_api_gatewayv2_integrationaws_api_gatewayv2_stageaws_appautoscaling_targetaws_auditmanager_assessmentaws_auditmanager_controlaws_auditmanager_frameworkaws_availability_zoneaws_backup_planaws_backup_vaultaws_cloudformation_stackaws_cloudfront_cache_policyaws_cloudfront_distributionaws_cloudfront_origin_access_identityaws_cloudfront_origin_request_policyaws_cloudtrail_trailaws_cloudwatch_alarmaws_cloudwatch_log_groupaws_cloudwatch_log_metric_filteraws_cloudwatch_log_streamaws_codebuild_projectaws_config_configuration_recorderaws_config_conformance_packaws_cost_by_account_dailyaws_cost_by_account_monthlyaws_cost_by_service_dailyaws_cost_by_service_monthlyaws_cost_by_service_usage_type_dailyaws_cost_by_service_usage_type_monthlyaws_cost_forecast_dailyaws_cost_forecast_monthlyaws_cost_usageaws_dax_clusteraws_dms_replication_instanceaws_dynamodb_backupaws_dynamodb_global_tableaws_dynamodb_tableaws_ebs_snapshotaws_ebs_volumeaws_ebs_volume_metric_read_opsaws_ebs_volume_metric_read_ops_dailyaws_ebs_volume_metric_read_ops_hourlyaws_ebs_volume_metric_write_opsaws_ebs_volume_metric_write_ops_dailyaws_ebs_volume_metric_write_ops_hourlyaws_ec2_amiaws_ec2_ami_sharedaws_ec2_application_load_balanceraws_ec2_autoscaling_groupaws_ec2_classic_load_balanceraws_ec2_gateway_load_balanceraws_ec2_instanceaws_ec2_instance_availabilityaws_ec2_instance_metric_cpu_utilizationaws_ec2_instance_metric_cpu_utilization_dailyaws_ec2_instance_metric_cpu_utilization_hourlyaws_ec2_instance_typeaws_ec2_key_pairaws_ec2_launch_configurationaws_ec2_load_balancer_listeneraws_ec2_network_interfaceaws_ec2_network_load_balanceraws_ec2_regional_settingsaws_ec2_ssl_policyaws_ec2_target_groupaws_ec2_transit_gatewayaws_ec2_transit_gateway_route_tableaws_ec2_transit_gateway_vpc_attachmentaws_ecr_repositoryaws_ecrpublic_repositoryaws_ecs_clusteraws_ecs_container_instanceaws_ecs_task_definitionaws_efs_access_pointaws_efs_file_systemaws_efs_mount_targetaws_eks_addonaws_eks_addon_versionaws_eks_clusteraws_elastic_beanstalk_applicationaws_elastic_beanstalk_environmentaws_elasticache_clusteraws_elasticache_parameter_groupaws_elasticache_replication_groupaws_elasticache_subnet_groupaws_elasticsearch_domainaws_emr_clusteraws_eventbridge_ruleaws_glacier_vaultaws_glue_catalog_databaseaws_guardduty_detectoraws_guardduty_findingaws_guardduty_ipsetaws_guardduty_threat_intel_setaws_iam_access_advisoraws_iam_access_keyaws_iam_account_password_policyaws_iam_account_summaryaws_iam_actionaws_iam_credential_reportaws_iam_groupaws_iam_policyaws_iam_policy_simulatoraws_iam_roleaws_iam_server_certificateaws_iam_useraws_iam_virtual_mfa_deviceaws_inspector_assessment_targetaws_inspector_assessment_templateaws_kinesis_consumeraws_kinesis_firehose_delivery_streamaws_kinesis_streamaws_kinesis_video_streamaws_kinesisanalyticsv2_applicationaws_kms_keyaws_lambda_aliasaws_lambda_functionaws_lambda_versionaws_rds_db_clusteraws_rds_db_cluster_parameter_groupaws_rds_db_cluster_snapshotaws_rds_db_instanceaws_rds_db_instance_metric_connectionsaws_rds_db_instance_metric_connections_dailyaws_rds_db_instance_metric_connections_hourlyaws_rds_db_instance_metric_cpu_utilizationaws_rds_db_instance_metric_cpu_utilization_dailyaws_rds_db_instance_metric_cpu_utilization_hourlyaws_rds_db_instance_metric_read_iopsaws_rds_db_instance_metric_read_iops_dailyaws_rds_db_instance_metric_read_iops_hourlyaws_rds_db_instance_metric_write_iopsaws_rds_db_instance_metric_write_iops_dailyaws_rds_db_instance_metric_write_iops_hourlyaws_rds_db_option_groupaws_rds_db_parameter_groupaws_rds_db_snapshotaws_rds_db_subnet_groupaws_redshift_clusteraws_redshift_event_subscriptionaws_redshift_parameter_groupaws_redshift_snapshotaws_redshift_subnet_groupaws_regionaws_route53_recordaws_route53_resolver_endpointaws_route53_resolver_ruleaws_route53_zoneaws_s3_access_pointaws_s3_account_settingsaws_s3_bucketaws_sagemaker_endpoint_configurationaws_sagemaker_modelaws_sagemaker_notebook_instanceaws_sagemaker_training_jobaws_secretsmanager_secretaws_securityhub_hubaws_securityhub_productaws_sns_topicaws_sns_topic_subscriptionaws_sqs_queueaws_ssm_associationaws_ssm_documentaws_ssm_maintenance_windowaws_ssm_managed_instanceaws_ssm_managed_instance_complianceaws_ssm_parameteraws_ssm_patch_baselineaws_vpcaws_vpc_customer_gatewayaws_vpc_dhcp_optionsaws_vpc_egress_only_internet_gatewayaws_vpc_eipaws_vpc_endpointaws_vpc_endpoint_serviceaws_vpc_flow_logaws_vpc_internet_gatewayaws_vpc_nat_gatewayaws_vpc_network_aclaws_vpc_routeaws_vpc_route_tableaws_vpc_security_groupaws_vpc_security_group_ruleaws_vpc_subnetaws_vpc_vpn_connectionaws_vpc_vpn_gatewayaws_waf_rate_based_ruleaws_waf_ruleaws_wafv2_ip_setaws_wafv2_regex_pattern_setaws_wafv2_rule_groupaws_wafv2_web_aclaws_wellarchitected_workload
On This Page
Get Involved

Table: aws_redshift_snapshot

Snapshots are point-in-time backups of a cluster. There are two types of snapshots: automated and manual. Amazon Redshift stores these snapshots internally in Amazon S3 by using an encrypted Secure Sockets Layer (SSL) connection.

Examples

Basic info

select
snapshot_identifier,
cluster_identifier,
node_type,
encrypted
from
aws_redshift_snapshot;

List manual snapshots

select
snapshot_identifier,
snapshot_type
from
aws_redshift_snapshot
where
snapshot_type = 'manual';

List unencrypted snapshots

select
snapshot_identifier,
cluster_identifier,
node_type,
number_of_nodes,
encrypted
from
aws_redshift_snapshot
where
not encrypted;

Get cluster info for each snapshot

select
snapshot_identifier,
cluster_identifier,
number_of_nodes,
cluster_version,
engine_full_version,
restorable_node_types
from
aws_redshift_snapshot;

List snapshots that are shared with other accounts

select
snapshot_identifier,
accounts_with_restore_access
from
aws_redshift_snapshot
where
accounts_with_restore_access is not null;

List accounts that are authorized to restore each snapshot

select
snapshot_identifier,
p ->> 'AccountId' as account_id,
p ->> 'AccountAlias' as account_alias
from
aws_redshift_snapshot,
jsonb_array_elements(accounts_with_restore_access) as p;

.inspect aws_redshift_snapshot

AWS Redshift Snapshot

NameTypeDescription
account_idtextThe AWS Account ID in which the resource is located.
accounts_with_restore_accessjsonbA list of the AWS customer accounts authorized to restore the snapshot.
actual_incremental_backup_size_in_mega_bytesdouble precisionThe size of the incremental backup.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
availability_zonetextThe Availability Zone in which the cluster was created.
backup_progress_in_mega-bytesdouble precisionThe number of megabytes that have been transferred to the snapshot backup.
cluster_create_timetimestamp without time zoneThe time (UTC) when the cluster was originally created.
cluster_identifiertextThe identifier of the cluster for which the snapshot was taken.
cluster_versiontextThe version ID of the Amazon Redshift engine that is running on the cluster.
current_backup_rate_in_mega_bytes_per_seconddouble precisionThe number of megabytes per second being transferred to the snapshot backup.
db_nametextThe name of the database that was created when the cluster was created.
elapsed_time_in_secondstextThe amount of time an in-progress snapshot backup has been running, or the amount of time it took a completed backup to finish.
encryptedbooleanIf true, the data in the snapshot is encrypted at rest.
encrypted_with_hsmbooleanA boolean that indicates whether the snapshot data is encrypted using the HSM keys of the source cluster.
engine_full_versiontextThe cluster version of the cluster used to create the snapshot.
enhanced_vpc_routingbooleanAn option that specifies whether to create the cluster with enhanced VPC routing enabled.
estimated_seconds_to_completiontextThe estimate of the time remaining before the snapshot backup will complete.
kms_key_idtextThe AWS KMS key ID of the encryption key that was used to encrypt data in the cluster from which the snapshot was taken.
maintenance_track_nametextThe name of the maintenance track for the snapshot.
manual_snapshot_remaining_daysbigintThe number of days until a manual snapshot will pass its retention period.
manual_snapshot_retention_periodbigintThe number of days that a manual snapshot is retained.
master_usernametextThe master user name for the cluster.
node_typetextThe node type of the nodes in the cluster.
number_of_nodesbigintThe number of nodes in the cluster.
owner_accounttextThe AWS customer account used to create or copy the snapshot.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
portbigintThe port that the cluster is listening on.
regiontextThe AWS Region in which the resource is located.
restorable_node_typesjsonbThe list of node types that this cluster snapshot is able to restore into.
snapshot_create_timetextThe time (in UTC format) when Amazon Redshift began the snapshot.
snapshot_identifiertextThe unique identifier of the cluster.
snapshot_retention_start_timetimestamp without time zoneA timestamp representing the start of the retention period for the snapshot.
snapshot_typetextThe snapshot type.
source_regiontextThe source region from which the snapshot was copied.
statustextThe snapshot status.
tagsjsonbA map of tags for the resource.
tags_srcjsonbThe list of tags for the cluster.
titletextTitle of the resource.
total_backup_size_in_mega_bytesdouble precisionThe size of the complete set of backup data that would be used to restore the cluster.
vpc_idtextThe VPC identifier of the cluster if the snapshot is from a cluster in a VPC.