sheetwork 💩🤦
What is sheetwork?
sheetwork is a handy open-source CLI-tool that allows non-coders to ingest Google Spreadsheets directly into their databases with control over data types, renaming, basic data sanitisation etc.
It offers a "close to no code" workflow that can still live alongside your codebase as all configuration lives in text files and is easily version-controllable. This makes it an ideal tool for teams.
⚠️ warning
sheetworkis still in its early inception (don't get fooled by the 1 in the version). Please do some testing before you end up using it in production, and feel free to report bugs.
compatibility:
- Python: 3.6, 3.7, 3.8 OS: Mac OSX >10.14, Linux
- So far all our unit tests work on Windows (tested in GitHub Actions) but no comprehensive testing has been done on this platform.
- sheetwork currently only offers support for cloud database Snowflake. However, its design follows an adapter pattern (currently in the making) and can be extended to interact with most databases. Feel free to check how you can contribute to the project or reach out on Discord..
Why use sheetwork?
Getting google sheets into any database often requires writing custom Python code that interacts with the Google API. That's fine if you can write Python, but it may not always be an option. On top of that, if your workflow requires you to ingest a bunch of sheets you may find yourself writing the same boiler plate code over and over.
Sheetwork offers a way to bring some DRY practices, standardisation, and simplification to basic google sheet ingestion. It won't do a lot of transformations and doesn't have room for baking in much transformational logic because we believe this is best done by fully-fledged ETL open-source tools such as dbt.
🙋🏻♂️ Want to use sheetwork on other databases? Let's talk! (Make an issue, or ping me on Discord)
Installation & Documentation
Head over to the pretty documentation.
1 maintainer
Metadata
1 maintainer
Release files for sheetwork 1.0.7
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| sheetwork-1.0.7.tar.gz | 33.4 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| sheetwork-1.0.7-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 74.1 kB
Release files / sheetwork-1.0.7.tar.gz
| Download URL | sheetwork-1.0.7.tar.gz |
|---|---|
| Size | 33.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
d13f25eb24c919688478b647ea81f891c4d71fe3e3cac80e1462bbaecfcfac39
|
|
BLAKE2b-256 checksum How to use checksums |
02bc9dbe41daaf2339023f5deb5206e0a18b7c05bc6b1acd93a1faf4062205c1
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.1.4 CPython/3.8.7 Darwin/20.2.0
|
Release files / sheetwork-1.0.7-py3-none-any.whl
| Download URL | sheetwork-1.0.7-py3-none-any.whl |
|---|---|
| Size | 40.7 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
9d30cdc8f298613d53599c04842b841fde84b0d81c0ad1c80c365cf4269c88f0
|
|
BLAKE2b-256 checksum How to use checksums |
da1290cedb06d2d36c867c9e5f63019d2e0c8cb57a3a6829f91ebcaa02918998
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/1.1.4 CPython/3.8.7 Darwin/20.2.0
|
