HEX
Server: Apache
System: Linux vps-cdc32557.vps.ovh.ca 5.15.0-156-generic #166-Ubuntu SMP Sat Aug 9 00:02:46 UTC 2025 x86_64
User: hanode (1017)
PHP: 7.4.33
Disabled: 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,pcntl_unshare,
Upload Files
File: //usr/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*.