I have some questions on the data factory copy activity . i would like to write azure synapse table to parquet .
from the sink I write a query . and I can choose 'Dynamic range' . The table have a date column . If I would like to break
each year a partition , for example 2010 to 2021
how should write the 'Parition upper bound' and 'Partition lower bound'?

for the sink, how to put each partition in a separate folder ???
/table/yyyy/*parquet.......
Oracle data source also support Dynamic range ??
