Hi, recently i tried security lake service which is just launched by AWS, I did followed all the required steps to run security lake, I was able to get my security lake created in s3 and able to see my data in ATHENA DB, but I am wondering can I visualize this data in Quicksight? Because when I am…

Hmmm, I haven’t worked the the security lake service yet. Are there IAM policies that are attached to it? If so, you might need to attach a policy that allows the quicksight user role to access it. [image] Unable to retrieve Athena workgroups Question & Answer I didn’t c…

umm, i am not sure but i guess yes as I was able to see my default athena DB and its tables. its like, security lake’s DB is not even in list of Databases.

Hi, I am encountering the same issue. Hope you could help me with the solution. In my Account A, I have a security lake with data like Security Hub findings, VPC flow logs, and CloudTrail logs stored in S3 buckets. I have enabled Lake Formation and it detected the S3 buckets datas and automatically…

Hi @SaulGoodman - You may need to created a trusted policy so that Account B Quick Sight should have access to Athena table in Account A. The best way to fix this issue to raise a ticket to AWS Customer support team so that they can guide you. To raise the ticket, please follow the link - Creating s…

Hi, thank you for responding. :slightly_smiling_face: Quick Sight and Athena are in the same account, which is Account B. In Account A, I have enabled security lake and lake formation, and data is stored in S3. I have given cross-account access to the S3 bucket to Account B and have also granted da…

Hi @SaulGoodman - I did face the same issue but when i tried adding the quicksight role that quicksight is using to query athena as the datalake admin - this worked for me as expected. I hope this helps. Thank you, Shravya

Security lake Athena db not visible for dataset selection

Q&A

shriramwasule December 13, 2022, 11:17am 4

hi,
Just an update, i am able to fetch the database and Tables of Security lake in Quicksight.
It was an Lakeformation permission issue we need to give permission to quicksight ARN of those Database and tables

Topic		Replies	Views
No matter what I try, I cannot see my glue crawler created tables in an Athena connection Q&A admin , data-source , quick-sight , navigation-and-user-experience , athena , tables	19	2748	October 30, 2023
Unable to select the database when creating dataset for Athena Q&A quick-sight , dataset , Business-Intelligence-Engineer	3	341	July 1, 2024
Q&A from the Live session \| Visualizing Amazon Security Lake Data with Quick Sight Q&A quick-sight , Business-Intelligence-Engineer , qls-security-lake	1	42	October 24, 2024
Access Denied when creating a new dataset with Athena Q&A feature-request , quick-sight , dataset	13	3957	March 9, 2023
Unable to connect Quicksight to athena as it Q&A data-source , error , database , quick-sight , dataset , Business-Intelligence-Engineer	3	273	December 27, 2023

Security lake Athena db not visible for dataset selection

Related topics