UDF constraints - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

UDF constraints

Within the constraints listed in this topic, you can use UDFs anywhere you use the Amazon Redshift built-in scalar functions. For more information, see SQL functions reference.

Amazon Redshift Python UDFs have the following constraints:

  • Python UDFs cannot access the network or read or write to the file system.

  • The total size of user-installed Python libraries cannot exceed 100 MB.

  • The number of Python UDFs that can run concurrently per cluster is limited to one-fourth of the total concurrency level for the cluster. For example, if the cluster is configured with a concurrency of 15, a maximum of three UDFs can run concurrently. After the limit is reached, UDFs are queued for execution within workload management queues. SQL UDFs don't have a concurrency limit. For more information, see Implementing workload management.

  • When using Python UDFs, Amazon Redshift doesn't support the SUPER and HLLSKETCH data types.