I have a working setup using Amplify, a lambda and dynamodb querying dynamodb the classic way with no issues.
Since yesterday I am trying to use PartiQL instead but no success, I always just get "ValidationException: Unexpected from source"
I have also downloaded the NoSqlWorkbench and I can connect to my database without any problems, list the items for the indices etc but when I try a basic PartiQL question, the error returned is the same as when using the lambda
In NoSQLWorkbench I have tried a few different queries, this being the simplest one I could think of:
select * from habits_sensors-playground
and I also tried what I think should get the data using the index such as:
select * from habits_sensors-playground.userId-gsi where userId='user1'
where habits_sensors-playground is the name of the table.
but like calling from the lambda, it returns the same "Unexpected from source" error.
I do see all my items listed in the NoSQLWorkbench so everything is working fine but I must be missing something with how to use PartiQL?
Crossposting from https://stackoverflow.com/questions/65888399/dynamodb-partiql-select-query-returns-validationexception-unexpected-from-sourc since I did not get any suggestions there.
All suggestions welcome, I must be missing something very basic.
Edited by: hubbobubbo on Jan 26, 2021 2:55 AM
Edited by: hubbobubbo on Jan 26, 2021 2:58 AM
Edited by: hubbobubbo on Jan 26, 2021 2:59 AM