ShibirG.99015 (Customer) asked a question.
athena-lake-formation-jdbc-okta - Integration
Hey Team,
Anyone tried below integration with Lake-formation:
We are getting below error even after integration:
Error Message :
SQL Error [100071] [HY000]: [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. Insufficient Lake Formation permission(s) on **** (Service: AmazonDataCatalog; Status Code: 400; Error Code: AccessDeniedException; Request ID: 09becb3f-f785-4d32-92b2-ff10659d31c9; Proxy: null) [Execution ID not available]
Hi @ShibirG.99015 (Customer) , Thank you for reaching out to the Okta Community!
The example error you provided implies that there is something wrong with the permissions.
I recommend checking "To create an IAM role for Amazon Lake Formation access" sub-points 3. & 4. under https://docs.amazonaws.cn/en_us/athena/latest/ug/security-athena-lake-formation-jdbc-okta-tutorial.html to make sure you've added "AmazonAthenaFullAccess" for the permissions policies.
Also check the following: https://aws.amazon.com/premiumsupport/knowledge-center/athena-insufficient-lake-formation-permissions/
If my answer helped, remember to mark it as best to increase its visibility for other members of the Okta Community who might have the same questions as you.
Hope it helps!