ERROR: External function my_proc_name cannot be accessed via Lake Formation

0

I have a procedure that suddenly stopped working, it resides in a redshift spectrum schema with lake formation. I tried to give the IAM role attached to this schema all the privileges that I could thought of, but I am still getting the same error: 'ERROR: External function my_proc_name cannot be accessed via Lake Formation.'

MY question: Does procedures even allowed to run in redshift spectrums with lake formation?

Any ideas? Thanks!

2 Answers
0

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

AWS
answered 8 months ago
0

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.

  1. 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

AWS
answered 7 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions