Skip to main content
Question

Make an analyse of DynamoDB from FME


geo-x
Contributor
Forum|alt.badge.img+1
  • Contributor

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.

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
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • July 22, 2020
david_r wrote:

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).


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings