1 Respuesta
- Más nuevo
- Más votos
- Más comentarios
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)
respondido hace 4 años
Contenido relevante
- OFICIAL DE AWSActualizada hace 3 años
- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace 3 años