Private
Server IP : 195.201.23.43  /  Your IP : 3.145.85.212
Web Server : Apache
System : Linux webserver2.vercom.be 5.4.0-192-generic #212-Ubuntu SMP Fri Jul 5 09:47:39 UTC 2024 x86_64
User : kdecoratie ( 1041)
PHP Version : 7.1.33-63+ubuntu20.04.1+deb.sury.org+1
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /lib/python3/dist-packages/awscli/examples/redshift/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /lib/python3/dist-packages/awscli/examples/redshift/restore-table-from-cluster-snapshot.rst
**To restore table from a cluster snapshot**

The following ``restore-table-from-cluster-snapshot`` example creates a new table from the specified table in the specified cluster snapshot. ::

    aws redshift restore-table-from-cluster-snapshot /
        --cluster-identifier mycluster /
        --snapshot-identifier mycluster-2019-11-19-16-17 /
        --source-database-name dev /
        --source-schema-name public /
        --source-table-name mytable /
        --target-database-name dev /
        --target-schema-name public /
        --new-table-name mytable-clone

Output::

    {
        "TableRestoreStatus": {
            "TableRestoreRequestId": "a123a12b-abc1-1a1a-a123-a1234ab12345",
            "Status": "PENDING",
            "RequestTime": "2019-12-20T00:20:16.402Z",
            "ClusterIdentifier": "mycluster",
            "SnapshotIdentifier": "mycluster-2019-11-19-16-17",
            "SourceDatabaseName": "dev",
            "SourceSchemaName": "public",
            "SourceTableName": "mytable",
            "TargetDatabaseName": "dev",
            "TargetSchemaName": "public",
            "NewTableName": "mytable-clone"
        }
    }

For more information, see `Restoring a Table from a Snapshot <https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-snapshots.html#working-with-snapshot-restore-table-from-snapshot>`__ in the *Amazon Redshift Cluster Management Guide*.
Private