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
• rtfcsTargetDatabaseName
• rtfcsSourceSchemaName
• rtfcsClusterIdentifier
• rtfcsSnapshotIdentifier
• rtfcsSourceDatabaseName
• rtfcsSourceTableName
• rtfcsNewTableName

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)

ToPath RestoreTableFromClusterSnapshot

Methods

toPath :: RestoreTableFromClusterSnapshot -> ByteString

ToHeaders RestoreTableFromClusterSnapshot

Methods

toHeaders :: RestoreTableFromClusterSnapshot -> [Header]

ToQuery RestoreTableFromClusterSnapshot

Methods

toQuery :: RestoreTableFromClusterSnapshot -> QueryString

type Rep RestoreTableFromClusterSnapshot

type Rep RestoreTableFromClusterSnapshot = D1 (MetaData "RestoreTableFromClusterSnapshot" "Network.AWS.Redshift.RestoreTableFromClusterSnapshot" "amazonka-redshift-1.4.2-6pcb6KeSjlW7uTiZZqVkvG" 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
• rtfcsrsResponseStatus

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.4.2-6pcb6KeSjlW7uTiZZqVkvG" 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.