Athena Federated Queries to DocumentDB: COLUMN_NOT_FOUND: line 1:8: Column cannot be resolved or requester is not authorized to access requested resources

0

I've got Athena setup to query a DocumentDB instance with the Lambda function built and AWS Glue configured. The setup was done through the datasource connector for DocumentDB.

I can see the database and the tables on the Athena page but, when I go to run queries I get one of the following error messages:

COLUMN_NOT_FOUND: line 1:8: SELECT * not allowed from relation that has no columns
COLUMN_NOT_FOUND: line 1:8: Column 'status' cannot be resolved or requester is not authorized to access requested resources

The queries that I've tried running but keep getting these errors:

SELECT "status" FROM "CustomerDB"."CustomerOders" limit 10;
SELECT "status" FROM "customerdb"."customeroders" limit 10;
texnoob
asked 8 months ago165 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions