Use a function in the Synapse data flow to specify a day-old folder.

Kakehi Shunya (筧 隼弥) 201 Reputation points
2022-08-30T07:09:43.393+00:00

I want to use a function in Synapse data flow to specify a folder that is one day old, but I don't know how to set up the function.
This is the function I am using now.

   concat('delta/year=',toString(currentDate('UTC'),'yyyy'),'/month=',toString(currentDate('UTC'),'MM'),'/day=',toString(currentDate('UTC'),'dd'))  

Do I use "addDays"?
Any answers would be appreciated.

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,412 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,335 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,471 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful