Fetch data from Tableau into a SQLite database
Project description
tableau-to-sqlite
Fetch data from Tableau into a SQLite database. A wrapper around TableauScraper.
Installation
Install this tool using pip
:
$ pip install tableau-to-sqlite
Usage
If you have the URL to a Tableau dashboard like this:
https://results.mo.gov/t/COVID19/views/VaccinationsDashboard/Vaccinations
You can pass that directly to the tool:
tableau-to-sqlite tableau.db \
https://results.mo.gov/t/COVID19/views/VaccinationsDashboard/Vaccinations
This will create a SQLite database called tableau.db
containing one table for each of the worksheepts in that dashboard.
If the dashboard is hosted on https://public.tableau.com/ you can instead provide the view name. This will be two strings separated by a /
symbol - something like this:
OregonCOVID-19VaccineProviderEnrollment/COVID-19VaccineProviderEnrollment
Now run the tool like this:
tableau-to-sqlite tableau.db \
OregonCOVID-19VaccineProviderEnrollment/COVID-19VaccineProviderEnrollment
Development
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:
pytest
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for tableau_to_sqlite-0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | af078d7c71e1fc9e42fbf34a833b802d1a226739b1f783d77394b2a18495090b |
|
MD5 | 1ff84d4309d878823858939a68b83810 |
|
BLAKE2b-256 | b0cb0d29155acbf2e7aef9444d5c66f9ef8e27014fb82b925db6efe64a340df5 |