1 of 1 people found this helpful
In the case of point -1 , Tableau will refresh the extract at the schedule time irrespective of your source table used in your data source have data loaded or not .
In scenario -2 : You have full control on when to trigger your extract ... example , you have a ETL job which load the table , Your script can wait for the ETL to finish loading the table (Once loading complete) you can have file watcher place on a shared path from ETL and your script will trigger the extract the moment it see a filewatcher(which means you have the latest data in table).
Your script can also send customize email to a distribution list which you can't achieve in your scenario-1 .
In scenario-1, You will get email only when extract failed not Success and secondly you can't send email to a distribution list (it will send the extract owner).
Hope this helps with pros & cons of triggering the extract through script vs using the tableau server scheduler.
Unless you want the custom option(setting dependency) on source/custom distribution on failure etc , you may not need the script option and the out of box schedule options work.
Excellent explaination Jambesh. I really liked the explaination.