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
Querying catalogs registered in the AWS Glue Data Catalog
After you register an Amazon Redshift data warehouse to the AWS Glue Data Catalog and set permissions for the resulting
catalog in AWS Lake Formation, the catalog is automatically mounted in all Amazon Redshift instances with access to the source data warehouse
in the same account and AWS Region. You can then query that catalog as you would a local cluster or workgroup.
You can also query catalogs registered to the AWS Glue Data Catalog using any SQL engine that supports the Apache Iceberg REST Open API.
For more information on querying catalogs in the AWS Glue Data Catalog using the Apache Iceberg REST API, see
Accessing the Data Catalog
in the AWS Glue Developer Guide. For information on the Apache Iceberg REST API, see the
Apache Iceberg REST Open API specification
To query a catalog, you must first set the permissions for the catalog using AWS Lake Formation. For more information on setting
permissions for catalogs in AWS Lake Formation, see
Setting up permissions for Amazon Redshift datashares
in the AWS Lake Formation Developer Guide. You also need an IAM role with the AmazonRedshiftServiceLinkedRolePolicy
managed policy attached. For information on service-linked roles, see
Using service-linked roles for Amazon Redshift
in the Amazon Redshift Management Guide.
Note that queries against catalogs must follow the following three-part syntax for accessing tables:
database@namespace.schema.table
For general information on querying Amazon Redshift data warehouses, see Query a database in the Amazon Redshift Management Guide.
