Please make sure to include (nolock) in your SQL Query. That should hopefully resolve it .
I'm sorry I didn't make it clear. The Read Lock is on the TDE File. There's no SQL Query. The lock is a file system lock (which appears as a Tableau Service acount holding the lock).
We have an Alteryx Workflow that creates the TDE file (which has the updated data)
Do you just dump the TDE on a shared drive or does the alteryx flow publish the TDE to server as the final step?
We just dump the TDE on a shared drive.
We then save it as a 'Saved Data Source' (Creating a TDS file).
And use a Tabcmd to publish the TDS file to the Server.
Our hope was that the TDS file (which contains the user filters, etc) would provide the ability for us to refresh the TDE anytime we wanted.
--but tableau seems to create a persistent read lock on the TDE file on the shared drive.
If I publish the TDE to the Server, no locking issues, but I am not able to apply the user filters to the data.
1 of 1 people found this helpful
You can apply a user filter to a published TDE on Tableau server.
The file locking I assume is a combo of Tableau and windows server.
Found the answer to my question through Tableau Support.
1. Save the TDE to a shared drive
2. Use a workbook to create/apply the user filters (as data source filters)
3. Publish the TDE to the Server from that workbook (Include external files should be checked)
This gets the TDE to the server with the user filters applied
(Essentially Tableau Server keeps track of the metadata and data separately)
4. You can now update the TDE on the shared drive anytime
5. When you want to publish the TDE to the server you can do it two ways.
1. Publish the TDE from the Workbook you used in Step 3.
2. Use Tabcmd with the -replace option (this will update the DATA, but not the metadata)
Hope that helps.