Network.AWS.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

restoreTableFromClusterSnapshot

Arguments

:: Text

rtfcsClusterIdentifier

-> Text

rtfcsSnapshotIdentifier

-> Text

rtfcsSourceDatabaseName

-> Text

rtfcsSourceTableName

-> Text

rtfcsNewTableName

-> RestoreTableFromClusterSnapshot

Creates a value of RestoreTableFromClusterSnapshot with the minimum fields required to make a request.

Use one of the following lenses to modify other fields as desired:

• rtfcsTargetSchemaName - The name of the schema to restore the table to.
• rtfcsTargetDatabaseName - The name of the database to restore the table to.
• rtfcsSourceSchemaName - 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 .
• rtfcsClusterIdentifier - The identifier of the Amazon Redshift cluster to restore the table to.
• rtfcsSnapshotIdentifier - 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.
• rtfcsSourceDatabaseName - The name of the source database that contains the table to restore from.
• rtfcsSourceTableName - The name of the source table to restore from.
• rtfcsNewTableName - The name of the table to create as a result of the current request.

data RestoreTableFromClusterSnapshot

See: restoreTableFromClusterSnapshot smart constructor.

Instances

Eq RestoreTableFromClusterSnapshot

Methods

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

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

Data RestoreTableFromClusterSnapshot

Methods

gfoldl :: (forall d b. Data d => c (d -> b) -> d -> c b) -> (forall g. g -> c g) -> RestoreTableFromClusterSnapshot -> c RestoreTableFromClusterSnapshot

gunfold :: (forall b r. Data b => c (b -> r) -> c r) -> (forall r. r -> c r) -> Constr -> c RestoreTableFromClusterSnapshot

toConstr :: RestoreTableFromClusterSnapshot -> Constr

dataTypeOf :: RestoreTableFromClusterSnapshot -> DataType

dataCast1 :: Typeable (* -> *) t => (forall d. Data d => c (t d)) -> Maybe (c RestoreTableFromClusterSnapshot)

dataCast2 :: Typeable (* -> * -> *) t => (forall d e. (Data d, Data e) => c (t d e)) -> Maybe (c RestoreTableFromClusterSnapshot)

gmapT :: (forall b. Data b => b -> b) -> RestoreTableFromClusterSnapshot -> RestoreTableFromClusterSnapshot

gmapQl :: (r -> r' -> r) -> r -> (forall d. Data d => d -> r') -> RestoreTableFromClusterSnapshot -> r

gmapQr :: (r' -> r -> r) -> r -> (forall d. Data d => d -> r') -> RestoreTableFromClusterSnapshot -> r

gmapQ :: (forall d. Data d => d -> u) -> RestoreTableFromClusterSnapshot -> [u]

gmapQi :: Int -> (forall d. Data d => d -> u) -> RestoreTableFromClusterSnapshot -> u

gmapM :: Monad m => (forall d. Data d => d -> m d) -> RestoreTableFromClusterSnapshot -> m RestoreTableFromClusterSnapshot

gmapMp :: MonadPlus m => (forall d. Data d => d -> m d) -> RestoreTableFromClusterSnapshot -> m RestoreTableFromClusterSnapshot

gmapMo :: MonadPlus m => (forall d. Data d => d -> m d) -> RestoreTableFromClusterSnapshot -> m RestoreTableFromClusterSnapshot

Read RestoreTableFromClusterSnapshot

Methods

readsPrec :: Int -> ReadS RestoreTableFromClusterSnapshot

readList :: ReadS [RestoreTableFromClusterSnapshot]

readPrec :: ReadPrec RestoreTableFromClusterSnapshot

readListPrec :: ReadPrec [RestoreTableFromClusterSnapshot]

Show RestoreTableFromClusterSnapshot

Methods

showsPrec :: Int -> RestoreTableFromClusterSnapshot -> ShowS

show :: RestoreTableFromClusterSnapshot -> String

showList :: [RestoreTableFromClusterSnapshot] -> ShowS

Generic RestoreTableFromClusterSnapshot

Associated Types

type Rep RestoreTableFromClusterSnapshot :: * -> *

Methods

from :: RestoreTableFromClusterSnapshot -> Rep RestoreTableFromClusterSnapshot x

to :: Rep RestoreTableFromClusterSnapshot x -> RestoreTableFromClusterSnapshot

Hashable RestoreTableFromClusterSnapshot

Methods

hashWithSalt :: Int -> RestoreTableFromClusterSnapshot -> Int

hash :: RestoreTableFromClusterSnapshot -> Int

NFData RestoreTableFromClusterSnapshot

Methods

rnf :: RestoreTableFromClusterSnapshot -> ()

AWSRequest RestoreTableFromClusterSnapshot

Associated Types

type Rs RestoreTableFromClusterSnapshot :: *

Methods

request :: RestoreTableFromClusterSnapshot -> Request RestoreTableFromClusterSnapshot

response :: MonadResource m => Logger -> Service -> Proxy * RestoreTableFromClusterSnapshot -> ClientResponse -> m (Response RestoreTableFromClusterSnapshot)

ToQuery RestoreTableFromClusterSnapshot

Methods

toQuery :: RestoreTableFromClusterSnapshot -> QueryString

ToPath RestoreTableFromClusterSnapshot

Methods

toPath :: RestoreTableFromClusterSnapshot -> ByteString

ToHeaders RestoreTableFromClusterSnapshot

Methods

toHeaders :: RestoreTableFromClusterSnapshot -> [Header]

type Rep RestoreTableFromClusterSnapshot

type Rep RestoreTableFromClusterSnapshot = D1 (MetaData "RestoreTableFromClusterSnapshot" "Network.AWS.Redshift.RestoreTableFromClusterSnapshot" "amazonka-redshift-1.5.0-Dab3rZV2tPBCgimwpoJly0" False) (C1 (MetaCons "RestoreTableFromClusterSnapshot'" PrefixI True) ((:*:) ((:*:) ((:*:) (S1 (MetaSel (Just Symbol "_rtfcsTargetSchemaName") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text))) (S1 (MetaSel (Just Symbol "_rtfcsTargetDatabaseName") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text)))) ((:*:) (S1 (MetaSel (Just Symbol "_rtfcsSourceSchemaName") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text))) (S1 (MetaSel (Just Symbol "_rtfcsClusterIdentifier") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Text)))) ((:*:) ((:*:) (S1 (MetaSel (Just Symbol "_rtfcsSnapshotIdentifier") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Text)) (S1 (MetaSel (Just Symbol "_rtfcsSourceDatabaseName") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Text))) ((:*:) (S1 (MetaSel (Just Symbol "_rtfcsSourceTableName") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Text)) (S1 (MetaSel (Just Symbol "_rtfcsNewTableName") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Text))))))

type Rs RestoreTableFromClusterSnapshot

type Rs RestoreTableFromClusterSnapshot = RestoreTableFromClusterSnapshotResponse

Request Lenses

rtfcsTargetSchemaName :: Lens' RestoreTableFromClusterSnapshot (Maybe Text)

The name of the schema to restore the table to.

rtfcsTargetDatabaseName :: Lens' RestoreTableFromClusterSnapshot (Maybe Text)

The name of the database to restore the table to.

rtfcsSourceSchemaName :: 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 .

rtfcsClusterIdentifier :: Lens' RestoreTableFromClusterSnapshot Text

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

rtfcsSnapshotIdentifier :: 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.

rtfcsSourceDatabaseName :: Lens' RestoreTableFromClusterSnapshot Text

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

rtfcsSourceTableName :: Lens' RestoreTableFromClusterSnapshot Text

The name of the source table to restore from.

rtfcsNewTableName :: Lens' RestoreTableFromClusterSnapshot Text

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

Destructuring the Response

restoreTableFromClusterSnapshotResponse

Arguments

:: Int

rtfcsrsResponseStatus

-> RestoreTableFromClusterSnapshotResponse

Creates a value of RestoreTableFromClusterSnapshotResponse with the minimum fields required to make a request.

Use one of the following lenses to modify other fields as desired:

• rtfcsrsTableRestoreStatus - Undocumented member.
• rtfcsrsResponseStatus - -- | The response status code.

data RestoreTableFromClusterSnapshotResponse

See: restoreTableFromClusterSnapshotResponse smart constructor.

Instances

Eq RestoreTableFromClusterSnapshotResponse

Methods

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

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

Data RestoreTableFromClusterSnapshotResponse

Methods

gfoldl :: (forall d b. Data d => c (d -> b) -> d -> c b) -> (forall g. g -> c g) -> RestoreTableFromClusterSnapshotResponse -> c RestoreTableFromClusterSnapshotResponse

gunfold :: (forall b r. Data b => c (b -> r) -> c r) -> (forall r. r -> c r) -> Constr -> c RestoreTableFromClusterSnapshotResponse

toConstr :: RestoreTableFromClusterSnapshotResponse -> Constr

dataTypeOf :: RestoreTableFromClusterSnapshotResponse -> DataType

dataCast1 :: Typeable (* -> *) t => (forall d. Data d => c (t d)) -> Maybe (c RestoreTableFromClusterSnapshotResponse)

dataCast2 :: Typeable (* -> * -> *) t => (forall d e. (Data d, Data e) => c (t d e)) -> Maybe (c RestoreTableFromClusterSnapshotResponse)

gmapT :: (forall b. Data b => b -> b) -> RestoreTableFromClusterSnapshotResponse -> RestoreTableFromClusterSnapshotResponse

gmapQl :: (r -> r' -> r) -> r -> (forall d. Data d => d -> r') -> RestoreTableFromClusterSnapshotResponse -> r

gmapQr :: (r' -> r -> r) -> r -> (forall d. Data d => d -> r') -> RestoreTableFromClusterSnapshotResponse -> r

gmapQ :: (forall d. Data d => d -> u) -> RestoreTableFromClusterSnapshotResponse -> [u]

gmapQi :: Int -> (forall d. Data d => d -> u) -> RestoreTableFromClusterSnapshotResponse -> u

gmapM :: Monad m => (forall d. Data d => d -> m d) -> RestoreTableFromClusterSnapshotResponse -> m RestoreTableFromClusterSnapshotResponse

gmapMp :: MonadPlus m => (forall d. Data d => d -> m d) -> RestoreTableFromClusterSnapshotResponse -> m RestoreTableFromClusterSnapshotResponse

gmapMo :: MonadPlus m => (forall d. Data d => d -> m d) -> RestoreTableFromClusterSnapshotResponse -> m RestoreTableFromClusterSnapshotResponse

Read RestoreTableFromClusterSnapshotResponse

Methods

readsPrec :: Int -> ReadS RestoreTableFromClusterSnapshotResponse

readList :: ReadS [RestoreTableFromClusterSnapshotResponse]

readPrec :: ReadPrec RestoreTableFromClusterSnapshotResponse

readListPrec :: ReadPrec [RestoreTableFromClusterSnapshotResponse]

Show RestoreTableFromClusterSnapshotResponse

Methods

showsPrec :: Int -> RestoreTableFromClusterSnapshotResponse -> ShowS

show :: RestoreTableFromClusterSnapshotResponse -> String

showList :: [RestoreTableFromClusterSnapshotResponse] -> ShowS

Generic RestoreTableFromClusterSnapshotResponse

Associated Types

type Rep RestoreTableFromClusterSnapshotResponse :: * -> *

Methods

from :: RestoreTableFromClusterSnapshotResponse -> Rep RestoreTableFromClusterSnapshotResponse x

to :: Rep RestoreTableFromClusterSnapshotResponse x -> RestoreTableFromClusterSnapshotResponse

NFData RestoreTableFromClusterSnapshotResponse

Methods

rnf :: RestoreTableFromClusterSnapshotResponse -> ()

type Rep RestoreTableFromClusterSnapshotResponse

type Rep RestoreTableFromClusterSnapshotResponse = D1 (MetaData "RestoreTableFromClusterSnapshotResponse" "Network.AWS.Redshift.RestoreTableFromClusterSnapshot" "amazonka-redshift-1.5.0-Dab3rZV2tPBCgimwpoJly0" False) (C1 (MetaCons "RestoreTableFromClusterSnapshotResponse'" PrefixI True) ((:*:) (S1 (MetaSel (Just Symbol "_rtfcsrsTableRestoreStatus") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe TableRestoreStatus))) (S1 (MetaSel (Just Symbol "_rtfcsrsResponseStatus") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Int))))

Response Lenses

rtfcsrsTableRestoreStatus :: Lens' RestoreTableFromClusterSnapshotResponse (Maybe TableRestoreStatus)

Undocumented member.

rtfcsrsResponseStatus :: Lens' RestoreTableFromClusterSnapshotResponse Int

• - | The response status code.