Skip to content

Restore Table From Snapshot

redshiftserverless_restore_table_from_snapshot R Documentation

Restores a table from a snapshot to your Amazon Redshift Serverless instance

Description

Restores a table from a snapshot to your Amazon Redshift Serverless instance. You can't use this operation to restore tables with interleaved sort keys.

Usage

redshiftserverless_restore_table_from_snapshot(
  activateCaseSensitiveIdentifier, namespaceName, newTableName,
  snapshotName, 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] The namespace of the snapshot to restore from.

newTableName

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

snapshotName

[required] The name of the snapshot 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_snapshot(
  activateCaseSensitiveIdentifier = TRUE|FALSE,
  namespaceName = "string",
  newTableName = "string",
  snapshotName = "string",
  sourceDatabaseName = "string",
  sourceSchemaName = "string",
  sourceTableName = "string",
  targetDatabaseName = "string",
  targetSchemaName = "string",
  workgroupName = "string"
)