I'm auto-generating .TDS files, and having problems with Tableau automatically adding in columns that I don't include (as hidden columns or otherwise) in the TDS.
The workflow, absent my tool, is as follows:
Does anyone know of a way to turn off the behavior in step 10, above, using a TDC customization or otherwise? I'd like to do this for SQL Server, and if possible for a generic ODBC source as well.
P.S. My tool is effectively doing steps 1-5. I can have it automatically add all the extra columns as "hidden" as a workaround, but this creates additional difficulties and I would prefer to simply set a boolean flag in an embedded TDC to disable step 10.
Assumed answer is "No; no such customization exists." The only option to disable the behavior is to add each column and mark it as hidden.
With help from my test team, I also learned that this automatic column addition behavior was not specific to SQL Server.