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
Amazon Redshift best practices for designing tables
As you plan your database, certain key table design decisions heavily influence overall query performance. These design choices also have a significant effect on storage requirements, which in turn affects query performance by reducing the number of I/O operations and minimizing the memory required to process queries.
In this section, you can find a summary of the most important design decisions and best practices for optimizing query performance. Automatic table optimization provides more detailed explanations and examples of table design options.