Table: aws_redshift_snapshots

This table shows data for Redshift Snapshots.

https://docs.aws.amazon.com/redshift/latest/APIReference/API_Snapshot.html (opens in a new tab)

The primary key for this table is arn.

Relations

This table depends on aws_redshift_clusters.

Columns

NameType
_cq_iduuid
_cq_parent_iduuid
account_idutf8
regionutf8
arn (PK)utf8
tagsjson
accounts_with_restore_accessjson
actual_incremental_backup_size_in_mega_bytesfloat64
availability_zoneutf8
backup_progress_in_mega_bytesfloat64
cluster_create_timetimestamp[us, tz=UTC]
cluster_identifierutf8
cluster_versionutf8
current_backup_rate_in_mega_bytes_per_secondfloat64
db_nameutf8
elapsed_time_in_secondsint64
encryptedbool
encrypted_with_hsmbool
engine_full_versionutf8
enhanced_vpc_routingbool
estimated_seconds_to_completionint64
kms_key_idutf8
maintenance_track_nameutf8
manual_snapshot_remaining_daysint64
manual_snapshot_retention_periodint64
master_usernameutf8
node_typeutf8
number_of_nodesint64
owner_accountutf8
portint64
restorable_node_typeslist<item: utf8, nullable>
snapshot_create_timetimestamp[us, tz=UTC]
snapshot_identifierutf8
snapshot_retention_start_timetimestamp[us, tz=UTC]
snapshot_typeutf8
source_regionutf8
statusutf8
total_backup_size_in_mega_bytesfloat64
vpc_idutf8