Restore Table From Recovery Point

redshiftserverless_restore_table_from_recovery_point

R Documentation

Restores a table from a recovery point to your Amazon Redshift Serverless instance

Description

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.

Usage

redshiftserverless_restore_table_from_recovery_point(
  activateCaseSensitiveIdentifier, namespaceName, newTableName,
  recoveryPointId, sourceDatabaseName, sourceSchemaName, sourceTableName,
  targetDatabaseName, targetSchemaName, workgroupName)

Arguments

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.

namespaceName

[required] Namespace of the recovery point to restore from.

newTableName

[required] The name of the table to create from the restore operation.

recoveryPointId

[required] The ID of the recovery point to restore the table from.

sourceDatabaseName

[required] The name of the source database that contains the table being restored.

sourceSchemaName

The name of the source schema that contains the table being restored.

sourceTableName

[required] The name of the source table being restored.

targetDatabaseName

The name of the database to restore the table to.

targetSchemaName

The name of the schema to restore the table to.

workgroupName

[required] The workgroup to restore the table to.

Value

A list with the following syntax:

list(
  tableRestoreStatus = list(
    message = "string",
    namespaceName = "string",
    newTableName = "string",
    progressInMegaBytes = 123,
    recoveryPointId = "string",
    requestTime = as.POSIXct(
      "2015-01-01"
    ),
    snapshotName = "string",
    sourceDatabaseName = "string",
    sourceSchemaName = "string",
    sourceTableName = "string",
    status = "string",
    tableRestoreRequestId = "string",
    targetDatabaseName = "string",
    targetSchemaName = "string",
    totalDataInMegaBytes = 123,
    workgroupName = "string"
  )
)

Request syntax

svc$restore_table_from_recovery_point(
  activateCaseSensitiveIdentifier = TRUE|FALSE,
  namespaceName = "string",
  newTableName = "string",
  recoveryPointId = "string",
  sourceDatabaseName = "string",
  sourceSchemaName = "string",
  sourceTableName = "string",
  targetDatabaseName = "string",
  targetSchemaName = "string",
  workgroupName = "string"
)