3 Replies Latest reply on Nov 15, 2017 10:11 AM by Miguel Chavez

    How to stop Tabelau to loading metadata while executing custom query

    chandrashekhar vastrad

      By default Tableau is running following queries for Custom Query  

       

      [Q 1]

      SELECT

          *

        FROM

          (

            SELECT

                *

              FROM

        test

          ) TableauSQL LIMIT 1

       

       

      [Q 2]

      SELECT

          *

        FROM

          TableauSQL LIMIT 1

       

      Here what is the "TableauSQL"? Is it temp created table. if so i have customized my Tableau to stop creating  Temp tables on fly as following

       

       

      <customizations>

          <customization name="CAP_SUPPRESS_DISCOVERY_QUERIES" value="yes"/>

          <customization name='SQL_AGGREGATE_FUNCTIONS' value='127' />

          <customization name='CAP_CREATE_TEMP_TABLES' value='yes' />

          <customization name='CAP_SKIP_CONNECT_VALIDATION' value='true' />

          <customization name='CAP_ODBC_METADATA_SUPPRESS_EXECUTED_QUERY' value='yes' />

          <customization name='CAP_ODBC_METADATA_SUPPRESS_PREPARED_QUERY' value='yes' />

          <customization name='CAP_ODBC_METADATA_SUPPRESS_SQLCOLUMNS_API' value='yes' />

          <customization name='CAP_ODBC_METADATA_SUPPRESS_SQLFOREIGNKEYS_API' value='yes' />

          <customization name='CAP_SELECT_INTO' value='no' />

          <customization name='CAP_QUERY_GROUP_BY_ALIAS' value='no' />

        </customizations>

       

       

      Is there any changes I need to do or add something in the above list?