tableau-inspect's Introduction

Tableau Inspect

When using Tableau, sometimes you need to know what Tableau did to your Database, this tool will print out the SQL Queries for you.

Install

First, make sure you have NodeJS installed and the command npm is available. Then execute npm i -g tableau-inspect to install the CLI command.

Usage

Start a console and execute command tableau-inspect
Use Tableau...
View SQL Queries on the console, there may be a delay about 3 or 5 seconds.

Demo

$ tableau-inspect
C:\Users\Me
## Tableau Repos: ## [
    "My Tableau Repository"
]
## Watching: Logs\log.txt (My Tableau Repository)
## Watching: Logs\tabprotosrv.txt (My Tableau Repository)

-----------------------------------------------------
#I 16:07:32 FROM Logs\log.txt (My Tableau Repository)

Key: qp-batch-summary; Elapsed: 0.05s

SELECT "t0"."store_id" AS "store_id",
  SUM((CASE WHEN ("t0"."__measure__0" > 10) THEN 1 ELSE 0 END)) AS "usr:Calculation_57814962331792"
FROM (
  SELECT "sales_fact_1997"."store_id" AS "store_id",
    "time_by_day"."day_of_month" AS "day_of_month",
    SUM("sales_fact_1997"."store_sales") AS "__measure__0"
  FROM "OLAP_TEST"."sales_fact_1997" "sales_fact_1997"
    INNER JOIN "OLAP_TEST"."time_by_day" "time_by_day" ON ("sales_fact_1997"."time_id" = "time_by_day"."time_id")
  WHERE ("sales_fact_1997"."store_id" IN (2, 3, 6, 7))
  GROUP BY "sales_fact_1997"."store_id",
    "time_by_day"."day_of_month"
) "t0"
GROUP BY "t0"."store_id"

#I 16:07:32 FROM Logs\log.txt (My Tableau Repository)
-----------------------------------------------------