Amazonka.Redshift.RestoreTableFromClusterSnapshot

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 RestoreTableFromClusterSnapshot 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 RestoreTableFromClusterSnapshot. 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 RestoreTableFromClusterSnapshot. This way, you can replace the original table with the table created from the snapshot.

Creating a Request

data RestoreTableFromClusterSnapshot

See: newRestoreTableFromClusterSnapshot smart constructor.

Constructors

RestoreTableFromClusterSnapshot'

Fields

• enableCaseSensitiveIdentifier :: Maybe Bool

  Indicates whether name identifiers for database, schema, and table are case sensitive. If true, the names are case sensitive. If false (default), the names are not case sensitive.

• sourceSchemaName :: Maybe Text

  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.

• targetDatabaseName :: Maybe Text

  The name of the database to restore the table to.

• targetSchemaName :: Maybe Text

  The name of the schema to restore the table to.

• clusterIdentifier :: Text

  The identifier of the Amazon Redshift cluster to restore the table to.

• snapshotIdentifier :: Text

  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 :: Text

  The name of the source database that contains the table to restore from.

• sourceTableName :: Text

  The name of the source table to restore from.

• newTableName' :: Text

  The name of the table to create as a result of the current request.

Instances

ToHeaders RestoreTableFromClusterSnapshot

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Methods

toHeaders :: RestoreTableFromClusterSnapshot -> [Header]

ToPath RestoreTableFromClusterSnapshot

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Methods

toPath :: RestoreTableFromClusterSnapshot -> ByteString

ToQuery RestoreTableFromClusterSnapshot

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Methods

toQuery :: RestoreTableFromClusterSnapshot -> QueryString

AWSRequest RestoreTableFromClusterSnapshot

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Associated Types

type AWSResponse RestoreTableFromClusterSnapshot

Methods

request :: (Service -> Service) -> RestoreTableFromClusterSnapshot -> Request RestoreTableFromClusterSnapshot

response :: MonadResource m => (ByteStringLazy -> IO ByteStringLazy) -> Service -> Proxy RestoreTableFromClusterSnapshot -> ClientResponse ClientBody -> m (Either Error (ClientResponse (AWSResponse RestoreTableFromClusterSnapshot)))

Generic RestoreTableFromClusterSnapshot

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Associated Types

type Rep RestoreTableFromClusterSnapshot :: Type -> Type

Methods

from :: RestoreTableFromClusterSnapshot -> Rep RestoreTableFromClusterSnapshot x

to :: Rep RestoreTableFromClusterSnapshot x -> RestoreTableFromClusterSnapshot

Read RestoreTableFromClusterSnapshot

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Methods

readsPrec :: Int -> ReadS RestoreTableFromClusterSnapshot

readList :: ReadS [RestoreTableFromClusterSnapshot]

readPrec :: ReadPrec RestoreTableFromClusterSnapshot

readListPrec :: ReadPrec [RestoreTableFromClusterSnapshot]

Show RestoreTableFromClusterSnapshot

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Methods

showsPrec :: Int -> RestoreTableFromClusterSnapshot -> ShowS

show :: RestoreTableFromClusterSnapshot -> String

showList :: [RestoreTableFromClusterSnapshot] -> ShowS

NFData RestoreTableFromClusterSnapshot

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Methods

rnf :: RestoreTableFromClusterSnapshot -> ()

Eq RestoreTableFromClusterSnapshot

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Methods

(==) :: RestoreTableFromClusterSnapshot -> RestoreTableFromClusterSnapshot -> Bool

(/=) :: RestoreTableFromClusterSnapshot -> RestoreTableFromClusterSnapshot -> Bool

Hashable RestoreTableFromClusterSnapshot

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Methods

hashWithSalt :: Int -> RestoreTableFromClusterSnapshot -> Int

hash :: RestoreTableFromClusterSnapshot -> Int

type AWSResponse RestoreTableFromClusterSnapshot

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

type AWSResponse RestoreTableFromClusterSnapshot = RestoreTableFromClusterSnapshotResponse

type Rep RestoreTableFromClusterSnapshot

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

type Rep RestoreTableFromClusterSnapshot = D1 ('MetaData "RestoreTableFromClusterSnapshot" "Amazonka.Redshift.RestoreTableFromClusterSnapshot" "amazonka-redshift-2.0-4tocKxBWIuj2GdXa6djdUl" 'False) (C1 ('MetaCons "RestoreTableFromClusterSnapshot'" 'PrefixI 'True) (((S1 ('MetaSel ('Just "enableCaseSensitiveIdentifier") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Bool)) :*: S1 ('MetaSel ('Just "sourceSchemaName") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Text))) :*: (S1 ('MetaSel ('Just "targetDatabaseName") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Text)) :*: S1 ('MetaSel ('Just "targetSchemaName") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe Text)))) :*: ((S1 ('MetaSel ('Just "clusterIdentifier") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 Text) :*: S1 ('MetaSel ('Just "snapshotIdentifier") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 Text)) :*: (S1 ('MetaSel ('Just "sourceDatabaseName") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 Text) :*: (S1 ('MetaSel ('Just "sourceTableName") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 Text) :*: S1 ('MetaSel ('Just "newTableName'") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 Text))))))

newRestoreTableFromClusterSnapshot

Arguments

:: Text

RestoreTableFromClusterSnapshot

-> Text

RestoreTableFromClusterSnapshot

-> Text

RestoreTableFromClusterSnapshot

-> Text

RestoreTableFromClusterSnapshot

-> Text

RestoreTableFromClusterSnapshot

-> RestoreTableFromClusterSnapshot

Create a value of RestoreTableFromClusterSnapshot with all optional fields omitted.

Use generic-lens or optics to modify other optional fields.

The following record fields are available, with the corresponding lenses provided for backwards compatibility:

$sel:enableCaseSensitiveIdentifier:RestoreTableFromClusterSnapshot', restoreTableFromClusterSnapshot_enableCaseSensitiveIdentifier - Indicates whether name identifiers for database, schema, and table are case sensitive. If true, the names are case sensitive. If false (default), the names are not case sensitive.

RestoreTableFromClusterSnapshot, restoreTableFromClusterSnapshot_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.

RestoreTableFromClusterSnapshot, restoreTableFromClusterSnapshot_targetDatabaseName - The name of the database to restore the table to.

RestoreTableFromClusterSnapshot, restoreTableFromClusterSnapshot_targetSchemaName - The name of the schema to restore the table to.

RestoreTableFromClusterSnapshot, restoreTableFromClusterSnapshot_clusterIdentifier - The identifier of the Amazon Redshift cluster to restore the table to.

RestoreTableFromClusterSnapshot, restoreTableFromClusterSnapshot_snapshotIdentifier - 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.

RestoreTableFromClusterSnapshot, restoreTableFromClusterSnapshot_sourceDatabaseName - The name of the source database that contains the table to restore from.

RestoreTableFromClusterSnapshot, restoreTableFromClusterSnapshot_sourceTableName - The name of the source table to restore from.

RestoreTableFromClusterSnapshot, restoreTableFromClusterSnapshot_newTableName - The name of the table to create as a result of the current request.

Request Lenses

restoreTableFromClusterSnapshot_enableCaseSensitiveIdentifier :: Lens' RestoreTableFromClusterSnapshot (Maybe Bool)

Indicates whether name identifiers for database, schema, and table are case sensitive. If true, the names are case sensitive. If false (default), the names are not case sensitive.

restoreTableFromClusterSnapshot_sourceSchemaName :: Lens' RestoreTableFromClusterSnapshot (Maybe Text)

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.

restoreTableFromClusterSnapshot_targetDatabaseName :: Lens' RestoreTableFromClusterSnapshot (Maybe Text)

The name of the database to restore the table to.

restoreTableFromClusterSnapshot_targetSchemaName :: Lens' RestoreTableFromClusterSnapshot (Maybe Text)

The name of the schema to restore the table to.

restoreTableFromClusterSnapshot_clusterIdentifier :: Lens' RestoreTableFromClusterSnapshot Text

The identifier of the Amazon Redshift cluster to restore the table to.

restoreTableFromClusterSnapshot_snapshotIdentifier :: Lens' RestoreTableFromClusterSnapshot Text

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.

restoreTableFromClusterSnapshot_sourceDatabaseName :: Lens' RestoreTableFromClusterSnapshot Text

The name of the source database that contains the table to restore from.

restoreTableFromClusterSnapshot_sourceTableName :: Lens' RestoreTableFromClusterSnapshot Text

The name of the source table to restore from.

restoreTableFromClusterSnapshot_newTableName :: Lens' RestoreTableFromClusterSnapshot Text

The name of the table to create as a result of the current request.

Destructuring the Response

data RestoreTableFromClusterSnapshotResponse

See: newRestoreTableFromClusterSnapshotResponse smart constructor.

Constructors

RestoreTableFromClusterSnapshotResponse'

Fields

• tableRestoreStatus :: Maybe TableRestoreStatus
• httpStatus :: Int

  The response's http status code.

Instances

Generic RestoreTableFromClusterSnapshotResponse

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Associated Types

type Rep RestoreTableFromClusterSnapshotResponse :: Type -> Type

Methods

from :: RestoreTableFromClusterSnapshotResponse -> Rep RestoreTableFromClusterSnapshotResponse x

to :: Rep RestoreTableFromClusterSnapshotResponse x -> RestoreTableFromClusterSnapshotResponse

Read RestoreTableFromClusterSnapshotResponse

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Methods

readsPrec :: Int -> ReadS RestoreTableFromClusterSnapshotResponse

readList :: ReadS [RestoreTableFromClusterSnapshotResponse]

readPrec :: ReadPrec RestoreTableFromClusterSnapshotResponse

readListPrec :: ReadPrec [RestoreTableFromClusterSnapshotResponse]

Show RestoreTableFromClusterSnapshotResponse

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Methods

showsPrec :: Int -> RestoreTableFromClusterSnapshotResponse -> ShowS

show :: RestoreTableFromClusterSnapshotResponse -> String

showList :: [RestoreTableFromClusterSnapshotResponse] -> ShowS

NFData RestoreTableFromClusterSnapshotResponse

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Methods

rnf :: RestoreTableFromClusterSnapshotResponse -> ()

Eq RestoreTableFromClusterSnapshotResponse

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

Methods

(==) :: RestoreTableFromClusterSnapshotResponse -> RestoreTableFromClusterSnapshotResponse -> Bool

(/=) :: RestoreTableFromClusterSnapshotResponse -> RestoreTableFromClusterSnapshotResponse -> Bool

type Rep RestoreTableFromClusterSnapshotResponse

Defined in Amazonka.Redshift.RestoreTableFromClusterSnapshot

type Rep RestoreTableFromClusterSnapshotResponse = D1 ('MetaData "RestoreTableFromClusterSnapshotResponse" "Amazonka.Redshift.RestoreTableFromClusterSnapshot" "amazonka-redshift-2.0-4tocKxBWIuj2GdXa6djdUl" 'False) (C1 ('MetaCons "RestoreTableFromClusterSnapshotResponse'" 'PrefixI 'True) (S1 ('MetaSel ('Just "tableRestoreStatus") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 (Maybe TableRestoreStatus)) :*: S1 ('MetaSel ('Just "httpStatus") 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedStrict) (Rec0 Int)))

newRestoreTableFromClusterSnapshotResponse

Arguments

:: Int

$sel:httpStatus:RestoreTableFromClusterSnapshotResponse'

-> RestoreTableFromClusterSnapshotResponse

Create a value of RestoreTableFromClusterSnapshotResponse with all optional fields omitted.

Use generic-lens or optics to modify other optional fields.

The following record fields are available, with the corresponding lenses provided for backwards compatibility:

$sel:tableRestoreStatus:RestoreTableFromClusterSnapshotResponse', restoreTableFromClusterSnapshotResponse_tableRestoreStatus - Undocumented member.

$sel:httpStatus:RestoreTableFromClusterSnapshotResponse', restoreTableFromClusterSnapshotResponse_httpStatus - The response's http status code.

Response Lenses

restoreTableFromClusterSnapshotResponse_tableRestoreStatus :: Lens' RestoreTableFromClusterSnapshotResponse (Maybe TableRestoreStatus)

Undocumented member.

restoreTableFromClusterSnapshotResponse_httpStatus :: Lens' RestoreTableFromClusterSnapshotResponse Int

The response's http status code.