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
demandé il y a 9 mois177 vues
Aucune réponse

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions