I figured out the code snippet given by pantab doesn't work. I also had issues with pantab. But I found out pandleau is working!
However I can't overwrite extracts without closing Tableau. But I also found out a way to kill the process, then I can overwrite and Tableau restarts the process when I press refresh on the Database. Not a clean method and probably might encounter a bug, we'll see after long period of testing. So far so good.
Here's the code to do that:
PROC_NAME = "hyperd.exe"
for proc in psutil.process_iter():
# check whether the process to kill name matches
if proc.name() == PROC_NAME:
1 of 1 people found this helpful
Thanks for the follow up! This is good advice and you are correct that once the extract is created and the process is open, it cannot be over-written.
Just for clarity, the packages your mention pantab and pandleau, while very useful, are created by 3rd party users and are not officially supported Tableau products.