redshift_restore_table_from_cluster_snapshot: Creates a new table from a table in an Amazon Redshift cluster snapshot

Description

Creates a new table from a table in an Amazon Redshift cluster snapshot. You must create the new table within the Amazon Redshift cluster that the snapshot was taken from.

You cannot use restore_table_from_cluster_snapshot to restore a table with the same name as an existing table in an Amazon Redshift cluster. That is, you cannot overwrite an existing table in a cluster with a restored table. If you want to replace your original table with a new, restored table, then rename or drop your original table before you call restore_table_from_cluster_snapshot. When you have renamed your original table, then you can pass the original name of the table as the NewTableName parameter value in the call to restore_table_from_cluster_snapshot. This way, you can replace the original table with the table created from the snapshot.

Usage

redshift_restore_table_from_cluster_snapshot(ClusterIdentifier,
  SnapshotIdentifier, SourceDatabaseName, SourceSchemaName,
  SourceTableName, TargetDatabaseName, TargetSchemaName, NewTableName)

Value

A list with the following syntax:

list(
  TableRestoreStatus = list(
    TableRestoreRequestId = "string",
    Status = "PENDING"|"IN_PROGRESS"|"SUCCEEDED"|"FAILED"|"CANCELED",
    Message = "string",
    RequestTime = as.POSIXct(
      "2015-01-01"
    ),
    ProgressInMegaBytes = 123,
    TotalDataInMegaBytes = 123,
    ClusterIdentifier = "string",
    SnapshotIdentifier = "string",
    SourceDatabaseName = "string",
    SourceSchemaName = "string",
    SourceTableName = "string",
    TargetDatabaseName = "string",
    TargetSchemaName = "string",
    NewTableName = "string"
  )
)

Arguments

ClusterIdentifier: [required] The identifier of the Amazon Redshift cluster to restore the table to.
SnapshotIdentifier: [required] The identifier of the snapshot to restore the table from. This snapshot must have been created from the Amazon Redshift cluster specified by the ClusterIdentifier parameter.
SourceDatabaseName: [required] The name of the source database that contains the table to restore from.
SourceSchemaName: The name of the source schema that contains the table to restore from. If you do not specify a SourceSchemaName value, the default is public.
SourceTableName: [required] The name of the source table to restore from.
TargetDatabaseName: The name of the database to restore the table to.
TargetSchemaName: The name of the schema to restore the table to.
NewTableName: [required] The name of the table to create as a result of the current request.

Request syntax

svc$restore_table_from_cluster_snapshot(
  ClusterIdentifier = "string",
  SnapshotIdentifier = "string",
  SourceDatabaseName = "string",
  SourceSchemaName = "string",
  SourceTableName = "string",
  TargetDatabaseName = "string",
  TargetSchemaName = "string",
  NewTableName = "string"
)