AWS Wrangler Error HIVE_METASTORE_ERROR: Table is missing storage descriptor
Hi! hope you can help me with a concern about an error with awswrangler. this is the case: i have 2 aws accounts, AccountA and AccountB, both with lakeformation enabled, i have a set of databases in AccA and another set in AccB, so we share AccountB databases to AccountA through lakeformation so we can query their Db/tables with Athena in AccountA.
i am trying to automate a sql with python, so i'm using awswrangler to achieve this, but i'm getting a not very specific error when in run the query in python.
when i run "select * from DatabaseAccB.Table" get this error "HIVE_METASTORE_ERROR: Table is missing storage descriptor" what could be the cause? i tried with boto3.Athena session and same result.
this may should help, when i query select * from DatabaseAccB.Table with my user, this runs fine. but when i try to do it with lambda or glue job, fails with error mentioned before.
PD: AccountA has only select/describe permission on tables in AccountB. Can show some code if you need.
Thanks!
If you are sharing the table via LakeFormation, every role/user trying to access the table should be granted permission explicitly. Please make sure that lambda's role & Glue job's role are granted permissions on the table in LakeFormation.
Relevant questions
Error! Cannot create the fleet. Reason: Current limit of fleets of 0 have been reached
asked 3 months agoAWS Marketplace: Grant distribution is not supported for this offer at this time.
asked 7 months agoTransit Gateway shared with AWS Resource Access Manager (AWS RAM) identify all accounts as external
Accepted Answerasked 3 years agoStorage Gateway migration between accounts
Accepted Answerasked 2 years agoMigrating AWS ses email identities from one aws account to another aws account
asked a month agoThe TagValue you have provided is invalid
asked 9 months agoAcount is in Suspended state
asked 5 months ago30 day limit - Delete an Organization with Many Accounts
asked a month agoEnrolling existing AWS accounts in new OU
asked 3 months agoAWS Wrangler Error HIVE_METASTORE_ERROR: Table is missing storage descriptor
asked 3 months ago