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
tableau-to-sqlite-0.1.tar.gz
(2.7 kB
view hashes)
Built Distribution
Close
Hashes for tableau_to_sqlite-0.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7f418d0feaba939fc1b20cf1143e3d8bec2464bceaa1212376c9171000119a12 |
|
MD5 | df46159005cb6f7a6c117270e8fb6f35 |
|
BLAKE2b-256 | 555d0762165c139532687700c17e30d7ca7b88937182faf014059838e06d1a2a |