RestoreTableFromRecoveryPoint
Restores a table from a recovery point to your Amazon Redshift Serverless instance. You can't use this operation to restore tables with interleaved sort keys.
Request Syntax
{
"activateCaseSensitiveIdentifier": boolean,
"namespaceName": "string",
"newTableName": "string",
"recoveryPointId": "string",
"sourceDatabaseName": "string",
"sourceSchemaName": "string",
"sourceTableName": "string",
"targetDatabaseName": "string",
"targetSchemaName": "string",
"workgroupName": "string"
}Request Parameters
For information about the parameters that are common to all actions, see Common Parameters.
The request accepts the following data in JSON format.
- activateCaseSensitiveIdentifier
-
Indicates whether name identifiers for database, schema, and table are case sensitive. If true, the names are case sensitive. If false, the names are not case sensitive. The default is false.
Type: Boolean
Required: No
- namespaceName
-
Namespace of the recovery point to restore from.
Type: String
Required: Yes
- newTableName
-
The name of the table to create from the restore operation.
Type: String
Required: Yes
- recoveryPointId
-
The ID of the recovery point to restore the table from.
Type: String
Required: Yes
- sourceDatabaseName
-
The name of the source database that contains the table being restored.
Type: String
Required: Yes
- sourceSchemaName
-
The name of the source schema that contains the table being restored.
Type: String
Required: No
- sourceTableName
-
The name of the source table being restored.
Type: String
Required: Yes
- targetDatabaseName
-
The name of the database to restore the table to.
Type: String
Required: No
- targetSchemaName
-
The name of the schema to restore the table to.
Type: String
Required: No
- workgroupName
-
The workgroup to restore the table to.
Type: String
Required: Yes
Response Syntax
{
"tableRestoreStatus": {
"message": "string",
"namespaceName": "string",
"newTableName": "string",
"progressInMegaBytes": number,
"recoveryPointId": "string",
"requestTime": number,
"snapshotName": "string",
"sourceDatabaseName": "string",
"sourceSchemaName": "string",
"sourceTableName": "string",
"status": "string",
"tableRestoreRequestId": "string",
"targetDatabaseName": "string",
"targetSchemaName": "string",
"totalDataInMegaBytes": number,
"workgroupName": "string"
}
}Response Elements
If the action is successful, the service sends back an HTTP 200 response.
The following data is returned in JSON format by the service.
- tableRestoreStatus
-
Contains information about a table restore request.
Type: TableRestoreStatus object
Errors
For information about the errors that are common to all actions, see Common Errors.
- ConflictException
-
The submitted action has conflicts.
HTTP Status Code: 400
- InternalServerException
-
The request processing has failed because of an unknown error, exception or failure.
HTTP Status Code: 500
- ResourceNotFoundException
-
The resource could not be found.
HTTP Status Code: 400
- ValidationException
-
The input failed to satisfy the constraints specified by an AWS service.
HTTP Status Code: 400
See Also
For more information about using this API in one of the language-specific AWS SDKs, see the following:
