View Tables not working on resource links in AWS Lake Formation

Question

Hello
I have created a resource link to a shared database from a different account. I am able to query the tables within the database but "Show tables from " and "View Tables" on the AWS Lake Formation UI is not working. Getting "Unknown exception occurred" error.

I have ensured the IAM Role has the required Describe permission on the Resource Link.

Error when executing "Show tables from "
- AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Unknown exception occurred. (Service: AWSGlue; Status Code: 500; Error Code: InternalServiceException; Request ID: 212c6029-dbd8-42ce-a313-84a5ed521352; Proxy: null))

Answer

Hi,

From the error message, I can see that the issue is coming from Glue and causing an Internal service Exception. Can you please check if you are able to see the database and tables from glue console? This is not an issue we have seen on our end and we would be needing more details on the issue, your resources and the cross account setup process.

Hence, I request you to please open a support case with AWS LakeFormation providing the error - https://docs.aws.amazon.com/awssupport/latest/user/case-management.html#creating-a-support-case

Thank you.

View Tables not working on resource links in AWS Lake Formation

Contenuto pertinente