Issue
When creating an extract from Vertica, the following error might occur:[Vertica][VerticaDSII] (20) An error occurred during query execution: out of memory for query result
It may be helpful to change the ResultBufferSize via a TDC customization if the resulting data set is excessively large. Consult with your Vertica Admin on the value for this buffer or for more information about this Vertica ODBC driver customization.
Example TDC entry: Setting the ResultBufferSize to 3GB.
<customization name='odbc-connect-string-extras' value='ResultBufferSize=3000000000;' />Important: Tableau does not test or support TDC files. These files should be used as a tool to explore or occasionally address issues with your data connection. Creating and maintaining TDC files requires careful manual editing, and there is no support for sharing these files.