UDF constraints - Amazon Redshift

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.