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
feita há 9 meses177 visualizações
Sem respostas

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas