Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the [ blog post ](https://amazonaws-china.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# Restoring a snapshot
<a name="serverless-snapshot-restore"></a>

**Note**  
No-backup tables aren't supported for RA3 provisioned clusters and Amazon Redshift Serverless workgroups. A table marked as no-backup in an RA3 cluster or serverless workgroup is treated as a permanent table that will always be backed up while taking a snapshot, and always restored when restoring from a snapshot. To avoid snapshot costs for no-backup tables, truncate them before taking a snapshot.

Restoring a snapshot to a serverless namespace replaces the current database with the database in the snapshot.

Restoring a snapshot to a serverless namespace is completed in two phases. The first phase completes in a few minutes, restores the data to your namespace, and makes it available for queries. The second phase of restoration is where your database is tuned, which can cause minor performance issues. This second phase can last from a few hours to several days, and in some cases, a couple of weeks. The amount of time depends on the size of the data, but performance progressively improves as the database gets tuned. At the end of this phase, your serverless namespace is fully tuned, and you can submit queries without performance issues.

**To restore a snapshot to a serverless namespace**

1. On the Amazon Redshift Serverless console, choose **Data backup**.

1. Choose the snapshot to restore. You can only restore one snapshot at a time.

1. Choose **Actions**, **Restore to serverless namespace**.

1. Choose an available namespace to restore to. You can only restore to namespaces whose statuses are Available.

1. Choose **Restore**.

**To restore a snapshot to a provisioned cluster**

1. On the Amazon Redshift Serverless console, choose **Data backup**.

1. Choose a snapshot to restore.

1. Choose **Action**, **Restore to provisioned cluster**.

1. Enter a cluster identifier.

1. Choose a **Node type**. The number of nodes depends on the node type.

1. Follow the instructions on the page on the console page to enter the properties for **Cluster configuration**. See [ Creating a cluster](https://docs.amazonaws.cn//redshift/latest/mgmt/create-cluster.html) for more information.

For more information about snapshots on provisioned clusters, see [Amazon Redshift snapshots and backups](https://docs.amazonaws.cn//redshift/latest/mgmt/working-with-snapshots.html).