Forum Discussion
Query Azure Storage Tables
I found this page. I wasn't able to get it to work with the Timestamp field, but I have another field stored as a string called ProcessedAt and that worked:
https://stackoverflow.com/questions/57176460/table-storage-dynamics-query-in-data-factory
My query looks like this:Variable Now = @addDays(formatDateTime(utcNow(),'MM-dd-yyyy'),-5)Query = @concat('ProcessedAt ge ''', variables('Now'),'''')
Not very intuitive, but at least it works.
I found this page. I wasn't able to get it to work with the Timestamp field, but I have another field stored as a string called ProcessedAt and that worked:
https://stackoverflow.com/questions/57176460/table-storage-dynamics-query-in-data-factory
My query looks like this:
Not very intuitive, but at least it works.
Hi daniel_sql_27 ,
I'm glad you were able to solve the problem yourself, and I'm sure it will help other users on the forum!
Best Regards
Yilong Zhou