Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
Create a zero-ETL integration for Amazon RDS
In this step, you create an Amazon RDS zero-ETL integration with Amazon Redshift. Redshift supports integrations with RDS for MySQL, RDS for PostgreSQL, and RDS for Oracle.
To create an Amazon RDS zero-ETL integration with Amazon Redshift
-
From the Amazon RDS console, create a custom DB parameter group as described in the Amazon RDS User Guide.
-
From the Amazon RDS console, create a source Amazon RDS instance as described in the Amazon RDS User Guide.
-
From the Amazon Redshift console: Create and configure a target Amazon Redshift data warehouse.
-
From the AWS CLI or Amazon Redshift console: Turn on case sensitivity for your data warehouse.
-
From the Amazon Redshift console: Configure authorization for your Amazon Redshift data warehouse.
-
-
From the Amazon RDS console, create a zero-ETL integration as described in the Amazon RDS User Guide.
-
From the Amazon Redshift console or the query editor v2, create an Amazon Redshift database from your integration.
Then, query and create materialized views with replicated data.
The Amazon RDS console offers a step-by-step integration creation flow, in which you specify the source database and the target Amazon Redshift data warehouse. If issues occur, then you can choose to have Amazon RDS fix the issues for you instead of manually fixing them on either the Amazon RDS or Amazon Redshift console.
For detailed instructions to create RDS zero-ETL integrations, see Creating Amazon RDS zero-ETL integrations with Amazon Redshift in the Amazon RDS User Guide.
For detailed instructions to specifically create an Amazon RDS for Oracle zero-ETL integration, see Setting up a zero-ETL integration in the Oracle Database@AWS User Guide.
