I am curious on what changes to metadata are being made when the workbook is being modified. Are these data types being modified, new columns, additional rows, or more dates? There might be another approach but I need to gain a deeper understanding of the ask first.
Also, one method would be to connect to the extract on Tableau Server in the new workbook, this would ensure that during the publication process the workbook would not be empty. As well as avoid the step of refreshing on the Tableau Server or waiting for the refresh to occur on the schedule.
Additionally, information on pro grammatically publishing the workbook to Tableau Server via the REST API I did find this information in the Tableau Product Help.
Hope this helps!
Thanks so much for the response. The changes to the metadata would be calculations mainly. That's what's requiring me to publish as an empty extract.
Would love to hear your 2nd option?
I believe that Tableau Document API might be the solution that you are looking for. The document API can be reviewed on the Tableau GitHub site found here: GitHub - tableau/document-api-python: Create and modify Tableau workbook and datasource files
I hope this helps!