Want to check Snapshot Restore Progress in Amazon Redshift? We can help you.

Recently, one of our customers was trying to restore a snapshot of his Amazon Redshift cluster.

However, he didn’t know how to check its progress.

Here, at Bobcares, we assist our customers with several AWS queries as part of our AWS Support Services.

Today, let us see how to monitor the progress of the snapshot restore.

Snapshot Restore Progress in Amazon Redshift

Generally, there are three snapshots restore options that Amazon Redshift supports.

• Cluster restore

Restores all tables, databases, and metadata from the snapshot to an Amazon Redshift cluster of the same size and node configuration as the source cluster.

• Cross-instance restore

Restores an Amazon Redshift snapshot to a cluster that is a different size or runs a different node type.

• Table restore

Restores specific tables and associated metadata from the snapshot to the Amazon Redshift cluster.

How to Monitor?

Moving ahead, let us see how our Support Techs use the above to monitor snapshots.

Monitor a cluster restore or cross-instance restore

In either of these ways, we can monitor the progress of the cluster restore or cross-instance restore:

• AWS Management Console

Initially, we go to the Amazon Redshift cluster details in the Amazon Redshift console.

When the cluster restore is in progress, its status is set to Modifying.

On the Clusters details page, we can select the Maintenance and monitoring tab.

This tab lists the events that confirm the creation of the Amazon Redshift cluster and the completion of any data transfers.

Once the restore operation completes, the cluster status is set to Available.

–Or–

• AWS CLI

In this case, to track the progress,  we can use the DescribeClusters API.

It shows snapshot details such as the size, transfer rate, time elapsed, and estimated remaining time in the snapshot restore.

Then, we can check the RestoreStatus entry to see if the snapshot is restored.

To check the status of the snapshot restore, we run:

aws redshift describe-clusters --cluster-identifier <value>

Monitor a table restore

To monitor the progress of the table restore we can use either of these ways:

• AWS Management Console

Once the table restore initiates, we can track the status of the request from the Amazon Redshift console.

On the Clusters page, the Backup tab lists any restore table requests. The Status tab shows the current state of the request.

–Or–

• AWS CLI

Here, we can use the describe-table-restore-status command to list the status of one or more table restores requests made using the RestoreTableFromClusterSnapshot API.

If we don’t specify a value for the TableRestoreRequestId parameter, then the DescribeTableRestoreStatus API returns the status of all table restore requests.

The requests will list in ascending order by date and time.

To obtain the status of the table restore, we run:

aws redshift describe-table-restore-status --cluster-identifier <mycluster>
aws redshift describe-table-restore-status --table-restore-request-id <value>

[Need help with the monitoring? We are here to assist you]

Conclusion

In short, we saw how our Support Techs monitor the Snapshot Restore Progress in Amazon Redshift.