Hello,
I'm current redeploying a CI/CD pipeline from a Legacy Terraform to Terraform on Cloud. The following error first appeared on the newly migrated pipelines:
HIVE_UNKNOWN_ERROR: com.amazonaws.services.lakeformation.model.InvalidInputException: Unable to assume role. Please verify Lake Formation has access to role arn:aws:iam::561######914:role/aws-reserved/sso.amazonaws.com/us-west-2/AWSReservedSSO_AdministratorAccess_0bb#####78e (Service: AWSLakeFormation; Status Code: 400; Error Code: InvalidInputException; Request ID: 73d56a83-6796-4cbe-befb-3e0b4e736773; Proxy: null)
After trying to grant permissions manually we oscillated between propagating this error to all databases on the project to retrieving this error to only a few databases.
We tried to grant permission through the Data lake permissions, with LF-Tags and also with the Databases. But without success.
Any idea on what to do?
A possible resource: https://aws.amazon.com/premiumsupport/knowledge-center/troubleshoot-lakeformation-data-catalog-permissions/