I’m trying to add a table from Athena for analysis. I’m able to query the data in Athena without any problems, but when creating a dataset in Quicksight I get
sourceErrorCode: TABLE_NOT_FOUND
sourceErrorMessage: No columns are found in the source. (considered as table not found.)
I have tried googling and searching this forum but without any luck. I guess it’s a permission problem somewhere, but I can’t figure out where. I have granted access to Athena and S3 buckets (all I can think of that might be appropriate for Quicksight) with write-permissions just to be sure.
Hi @Sewen - Welcome to AWS QuickSight community and thanks for posting the question. Did you add Athena and S3 services from QuickSight console. Can you please go to
Qucksight → Manage QuickSight → Security & Permission → QuickSight access to AWS services → select Athena and S3 and provide the require S3 bucket.
After doing it, please try to access Athena table, if possible share the screenshot as well.
Added all s3-buckets that I can think of being important (tried adding all as well) including write-permissions. Looking at the role and policies in IAM it looks like the permissions are there, but not sure what the exact permissions should be.
No, that didn’t help. I tried recreating all buckets and tables and again grant permissions to all of them in Quicksight. Tried with a test-table with less data to see if there’s some problems there. Double checked that there is no encryption enabled either. Not sure what my next steps will be.
I can query successfully in Athena, but not from Quicksight. Always getting the same error
sourceErrorCode: TABLE_NOT_FOUND
sourceErrorMessage: No columns are found in the source. (considered as table not found.)
I also tried with a custom SQL query with this output:
SourceErrorCode: 100071
SourceErrorMessage: [Simba]AthenaJDBC An error has been thrown from the AWS Athena client. COLUMN_NOT_FOUND: line 2:27: Column ‘member_id’ cannot be resolved [Execution ID: 0bcde15b-a1bf-4b0e-a7ad-789e3ebc2f0d]
Hi @Sewen - Ok, the data looks ok. Can you create a new session and try to connect this table and see whether it is able to import it from QuickSight or not. If not, better to please raise a ticket to AWS Customer support team so that they can see your environment by screen share and advise you. To raise a ticket, please follow the link - Creating support cases and case management - AWS Support.
If you do not have access, request your aws admin to help you on this.
Hi @Sewen - Also, can you create test table with 2 rows and put some dummy data and test it, just to ensure you do not have access in connection from QuickSight to Athena and the issue is pure related to data.
This is a dummy table with some dummy data. The original table is much bigger both in terms of columns as well as number rows.
I can see in CloudTrail that Quicksight is executing this query: SELECT ds.* FROM ( SELECT member_id, created_at from "training"."test_table" ) ds LIMIT 0;
Which doesn’t return any data for me either in Athena. What is that query supposed to do?
The output location. I cannot see any files written to the outputLocation defined for Quicksight. It has access to putObject according to IAM policy though.
The Database for Quicksight is default? I guess that might not be a problem since I do define the table in the query, but not sure.
Are there any special permissions needed for viewing the schema? In Glue I have defined the table using the Glue Schema Registry. But it should take the schema from the table, right?
Anything other with the table creation that might mess things up?
Thanks @Sewen . Please do a test and update this community and marked your analysis as solution so that it can useful to the whole community. sometime a simple permission issue took time to troubleshoot but good part with that phase you are learning so many new things.
And that solved my problem. Seems the role didn’t have permissions to list and get the schema versions for my tables. @Kristin, perhaps those actions should be added to the managed policy AWSQuicksightAthenaAccess? Let me know if you want more information about my setup so that no-one else ends up with the same problem as I have.
Thanks @Sanjeeb2022 for all you efforts trying to help me! Very much appreciated!