Amazon Redshift
API Reference (API Version 2012-12-01)
AWS services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with AWS services in China.


Lists the status of one or more table restore requests made using the RestoreTableFromClusterSnapshot API action. If you don't specify a value for the TableRestoreRequestId parameter, then DescribeTableRestoreStatus returns the status of all table restore requests ordered by the date and time of the request in ascending order. Otherwise DescribeTableRestoreStatus returns the status of the table specified by TableRestoreRequestId.

Request Parameters

For information about the parameters that are common to all actions, see Common Parameters.


The Amazon Redshift cluster that the table is being restored to.

Type: String

Required: No


An optional pagination token provided by a previous DescribeTableRestoreStatus request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by the MaxRecords parameter.

Type: String

Required: No


The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, a pagination token called a marker is included in the response so that the remaining results can be retrieved.

Type: Integer

Required: No


The identifier of the table restore request to return status for. If you don't specify a TableRestoreRequestId value, then DescribeTableRestoreStatus returns the status of all in-progress table restore requests.

Type: String

Required: No

Response Elements

The following elements are returned by the service.


A pagination token that can be used in a subsequent DescribeTableRestoreStatus request.

Type: String


A list of status details for one or more table restore requests.

Type: Array of TableRestoreStatus objects


For information about the errors that are common to all actions, see Common Errors.


The ClusterIdentifier parameter does not refer to an existing cluster.

HTTP Status Code: 404


The specified TableRestoreRequestId value was not found.

HTTP Status Code: 400

See Also

For more information about using this API in one of the language-specific AWS SDKs, see the following: