Hello Team,
I am working on generating reports in Quick Sight using tables from the AWS-provided Amazon Connect Analytics Data Lake. I followed the steps outlined in this AWS blog post to set up the data lake and create the necessary tables.
Currently, I am able to:
See the table name and schema in Athena.
Successfully run queries against the table in Athena.
However, when I try to visualize the same table in Quick Sight, I encounter the following issue:
Quick Sight displays a “table not found” error.
When attempting to use custom SQL, I receive the error: TABLE_NOT_FOUND - No columns are found in the source. (considered as table not found.)
Has anyone experienced this issue or have suggestions on how to resolve it? The table exists and I am able to query it in Athena, and the schema appears correct. Any guidance on troubleshooting this error in Quick Sight would be greatly appreciated.
Ensure the Quick Sight service role has permission to access both Athena and the underlying S3 buckets storing table data. This includes List and Read permissions for the target buckets and Athena query result buckets.
Please refer to the below Quick Sight documentations and community post this might be helpful for you.
Thanks for the reply @Xclipse !
I had access to the table but not its columns. To resolve this, I followed Manage access to Resource link tables - Amazon Connect documentation for managing access to resource link tables. I granted the Quick Sight user access to the resource link and then provided “Grant on Target.” Now, I’m able to create the dataset without any issues.
Appreciate your support!
