tableau-to-sqlite by simonw

23 downloads this week        Star

README source code


PyPI Changelog Tests License

Fetch data from Tableau into a SQLite database. A wrapper around TableauScraper.


Install this tool using pip:

$ pip install tableau-to-sqlite


If you have the URL to a Tableau dashboard like this:

You can pass that directly to the tool:

tableau-to-sqlite tableau.db \

This will create a SQLite database called tableau.db containing one table for each of the worksheets in that dashboard.

If the dashboard is hosted on you can instead provide the view name. This will be two strings separated by a / symbol - something like this:


Now run the tool like this:

tableau-to-sqlite tableau.db \

Get the data as JSON or CSV

If you're building a git scraper you may want to convert the data gathered by this tool to CSV or JSON to check into your repository.

You can do that using sqlite-utils. Install it using pip:

pip install sqlite-utils

You can dump out a table as JSON like so:

sqlite-utils rows tableau.db \
   'Admin Site and County Map Site No Info' > tableau.json

Or as CSV like this:

sqlite-utils rows tableau.db --csv \
   'Admin Site and County Map Site No Info' > tableau.csv


To contribute to this tool, first checkout the code. Then create a new virtual environment:

cd tableau-to-sqlite
python -mvenv venv
source venv/bin/activate

Or if you are using pipenv:

pipenv shell

Now install the dependencies and tests:

pip install -e '.[test]'

To run the tests: