Option 2 It may be possible to automate this process using both Tabcmd and Alteryx, however please note that such a process not supported by Tableau Technical Support. For more information, see this posting by Interworks on automating a datasource refresh using Alteryx.
When a datasource is published to Tableau Server using Tableau Desktop, that data has an XML header that contains info such as calculated fields, color formats, connection information and other datasource-specific settings. When Alteryx creates data to be published to Tableau Server, it does not contain this XML data and that information is lost when the datasource is overwritten. When the workbook attempts to render the view without the XML data, the calculated fields do not get created and cannot be used to render the view, resulting in a blank screen and "red pills" on the dashboard.
Thank you for providing your feedback on the effectiveness of the article.