1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
"SYNTAX_ERROR: line 1:19: Table awsdatacatalog.default.lambda-dynamodb-stream does not exist"
You are referencing the Glue Catalog in your query, that will not work for your DynamoDB table. You have to create a new data source; refer to part 2 of this doc : https://docs.aws.amazon.com/athena/latest/ug/connect-to-a-data-source-lambda.html
On Athena console You have to create a new data source to query your DynamoDB :
- Choose DynamoDB, and pick your Lambda function.
- Choose a catalog name: ("ddb" for example) => it's this name that you need to specify when querying your DynamoDB tables. In this case :
select value from ddb.default.lambda-dynamodb-stream
Please note that if you don't have a table defined in the Glue catalog that matches your DynamoDB table name, then the schema will be inferred by the DynamoDB Connector, as described here (https://github.com/awslabs/aws-athena-query-federation/blob/master/athena-dynamodb/README.md#setting-up-databases--tables-in-glue)
répondu il y a 4 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- Réponse acceptéedemandé il y a 7 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 8 mois