{"repo":"bastienboutonnet/sheetwork","free":true,"listed":false,"github":"https://github.com/bastienboutonnet/sheetwork","clone":"git clone https://github.com/bastienboutonnet/sheetwork.git","description":"A handy package to load Google Sheets to your database right from the CLI and with easy configuration via YAML files.","language":"Python","stars":15,"topics":["google-sheets","cli","database","snowflake","python","sql","data-engineering","etl"],"license":"MIT","category":"databases-storage","readme_excerpt":"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 sheetwork is 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 prac","default_branch":null,"files":null,"tree":[],"storefront":"/r/bastienboutonnet","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/bastienboutonnet/sheetwork/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}