Skip to main content
Question

Make an analyse of DynamoDB from FME

  • July 22, 2020
  • 2 replies
  • 28 views

geo-x
Supporter
Forum|alt.badge.img+6

Dear FME community.

I've DynamoDB DataBase. In this DB, directly in AWS I can make a request (for example I can select only data between two dates) :

It's necessary for don't scan all the table.

In FME I can see the equivalent of the classical query in DynamoDB base on the index :

Like

The problem is, in this case, I must choose one value before to choose an other filter.

Do you know how can I make a filter lika the "analyser" in FME ?

Thanks.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

david_r
Celebrity
  • July 22, 2020

I've never tested this myself, but according to the documentation it should be possible to use the "Between" operator (opérateur de triage) rather than < and >. Would that be a possibility?

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/dynamodb/dynamodb_reader.htm


geo-x
Supporter
Forum|alt.badge.img+6
  • Author
  • Supporter
  • July 22, 2020

I've never tested this myself, but according to the documentation it should be possible to use the "Between" operator (opérateur de triage) rather than < and >. Would that be a possibility?

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/dynamodb/dynamodb_reader.htm

Hi @david_r and thanks for your reply.

In this case, yes it is possible to use the "Between" operator but we must to have a unique key before (the partition key).