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
질문됨 9달 전177회 조회
답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠