SQL parser for Tableau custom SQL requests
Given a .twb or a .twbx Tableau archive, you can extract as a report these information:
- number of queries analyzed
- tables used
- a tree-like structure describing
schema.tables.column
Requirement : install uv globally (with brew for example)
Then run uv sync
Then download a Tableau archive (.twbx or .twb)
Then run uv run sqlparse -f file/to/parse/archive.twb(x) -r custom_report_name -o to extract the report
As many modern data stacks use dbt, you will be asked to add the manifest.json of your dbt project.
It is not mandatory but the report will provide more accurate results.
The file will be cached and can be used, replaced or deleted.
Type uv run sqlparse --help for more details.