forums

Use these forums to ask questions and discuss Tableau.

Exposing SQL statements

Posted April 18th, 2008 by Aaron
in Data Sources and Performance

I have begun making greater use of the RAWSQL functions, and in so doing it is useful to see how Tableau is naming objects and structuring the SQL statement that it is sending to the server for a given visualization. I know that I can see the statement when there is an error, but I don't know how to view the statement when it is functioning properly.

Does anyone know how to view these background SQL statements?

Add new comment

Comments

On April 18th, 2008 Dan Jewett said:

You can see the sql that gets sent to the database in the log files. These files are stored in c:\My Documents\My Tableau Repository\Logs

The most recent statements that get sent will be in log.txt. Just open it with any editor, notepad for example, and scroll to the bottom. You'll then be able to find the most recent statements you've sent and scroll up from there.

There isn't a 'view sql' window or command inside the user interface - the log file is place to look.

 

Dan Jewett
Tableau Software

reply