Azure Table Storage with Lookup activity to obtain max date

Question

Hi,

I'm trying to use a lookup in datafactory to get the maximum date value stored in a column from my azure table storage but I can't get the desired result. Can you help me with the query syntax?

Answer 1

Hi @Clara Pantoja Salado ,

Welcome to Microsoft Q&A platform and thanks for posting your question here.

As I understand your issue, you are trying to get max date value from a column in table storage. Please let me know if that is not the ask.

According to 'Querying tables and entities' documentation , the supported operators are : Equal,GreaterThan,GreaterThanOrEqual ,LessThan ,LessThanOrEqual, ,NotEqual, And, or and Not

There is no direct option to get the max date . I would suggest you to copy the data to ADLS and get the max date value using Dataflow (cache sink). Or, copy the data to SQL server table and use SQL query on top of it to get max value.

Resources: Cache Sink and Cached lookup in Mapping Data Flow in Azure Data Factory

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators