1 Reply Latest reply on Dec 5, 2018 9:22 PM by Ritesh Bisht

    SQL behind View

    Vibhu S

      Hi,

       

      I am unable to see SQL behind attached View. Query section in performance recording is showing empty and log file has several SQL statements making it difficult to find

        • 1. Re: SQL behind View
          Ritesh Bisht

          Hi Vibhu,

           

          Please vote up the idea at the end

           

          Question

          How to view the SQL queries issued from Tableau to the data source.

          Environment

          • Tableau Desktop
          • Tableau Server

          Answer

          Option 1: Use the Performance Recording Feature

          For more information, see Create a Performance Recording

          and Interpret a Performance Recording Workbook

          for Tableau Desktop and Create a Performance Recording

          for Tableau Server.

          Option 2: Review the Logs

          In Tableau Desktop:

          • Navigate to the Logs folder inside the My Tableau Repository folder.
          • By default, the My Tableau Repository can be found inside the My Documents folder on Windows or the Documents folder on a Mac.
          • If you have a live connection to the data source, check the log.txt and tabprotosrv.txt files.
          • If you are using an extract, check the tdeserver.txt file.
          • The tabprotosrv.txt file often shows detailed information about queries.

          In Tableau Server:

          1. Generate a snapshot of Server logs.
          2. Unzip the archive logs.zip file.
          3. Navigate to the vizqlserver folder.
          4. Search for lines containing begin-query in the .txt files.

          Additional Information

          To voice your support for the inclusion of this feature in a future product release, add your vote to the following Community Idea: Show SQL Code

           

          Thanks,

          Ritesh

          Please mark the answer if helpful so that it can help others as well

          .