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
You need to know the name of the Tableau view you want to import. 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
This will create a SQLite database called tableau.db
containing one table for each of the worksheepts in the view.
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
Close
Hashes for tableau_to_sqlite-0.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 119f7c02b7dcd2342ab609b64f8486fb3b39cb6ae1bb8192937f965b1459c346 |
|
MD5 | 0e4b8f214aa6524ab258c0e8b8b5dba9 |
|
BLAKE2b-256 | 1475a0225a18067dcf4d2ee271c48169b6013549dcee80473aa30e66b684a76a |