ERROR: External function my_proc_name cannot be accessed via Lake Formation

Hi The error message you're encountering, "ERROR: External function my_proc_name cannot be accessed via Lake Formation," indicates an issue with accessing an external function named "my_proc_name" through AWS Lake Formation.   The error message suggests that the external function you're trying to access is not configured correctly or doesn't have the necessary permissions in Lake Formation. When Amazon Redshift users create an external schema on a database in the AWS Glue Data Catalog, they can query only the tables and columns in that schema on which they have Lake Formation permissions.[1]   To resolve the issue please move external functions to a local schema   References: [1] Using AWS Lake Formation with Amazon Redshift Spectrum: https://docs.aws.amazon.com/lake-formation/latest/dg/RSPC-lf.html

Hello,

Yes, procedures can be used in Amazon Redshift spectrum with Lake formation. However the error massage indicates an issue with accessing an external function via Lake Formation. Here are a few things you can do to fix this issue:

1. Check IAM permissions: Make sure that the IAM role attached to your Redshift has necessary permissions such as accessing the necessary tables, columns, and databases.

2.Recreate the External Function: You can try dropping the existing external function and then recreating it with the correct permissions and metadata.

3. Check for Updates: Check if there have been any updates to Redshift, Spectrum, or Lake Formation.

References: Using AWS Lake Formation with Amazon Redshift Spectrum: https://docs.aws.amazon.com/lake-formation/latest/dg/RSPC-lf.html