Kindly help us, the Azure Synapse Link for Dataverse with Azure Data Lake, while adding or manage the tables, there is advanced setting while choose the tables for Append only ( Yes or No ), if I choose Yes, the partition automatically choose Yearly and if we go for Append No, the partition will be like Month. we would like explain what is pros and cons if we choose Yes and NO. the document also not much information available.
https://docs.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-data-lake
above link provide information as below only, please help us on more details.
The Count column shows the number rows written. When Append only is set to No, this is the total number of records. When Append Only is set to Yes, this is the total number of changes. The Append only and Partition strategy columns show the usage of different advanced configurations.
Kindly share your comments for this.