Cloud Database Data Automation
Budget: $250 – $750 USD
I have a sizeable dataset sitting in a cloud-hosted database and I need it moved into a structured spreadsheet (or CSV) through an automated workflow rather than by hand. The task involves:
• Connecting to the cloud database, extracting the required tables and fields, then mapping them to the target format.
• Building or scripting an automated routine so future imports can run with a single command or on a schedule.
• Supplying clear hand-off instructions and well-commented code so I can update credentials or tweak field mappings later.
The database already exposes standard connection endpoints; you are free to use Python, Node, or any other language you prefer as long as the end result is reliable and reproducible. I would also like basic logging built in so I can confirm each run’s success without digging through the raw data.
When you deliver, I’ll review the script’s readability, run the workflow against a test table, and sign off once the exported file matches the source records one-to-one.
• Connecting to the cloud database, extracting the required tables and fields, then mapping them to the target format.
• Building or scripting an automated routine so future imports can run with a single command or on a schedule.
• Supplying clear hand-off instructions and well-commented code so I can update credentials or tweak field mappings later.
The database already exposes standard connection endpoints; you are free to use Python, Node, or any other language you prefer as long as the end result is reliable and reproducible. I would also like basic logging built in so I can confirm each run’s success without digging through the raw data.
When you deliver, I’ll review the script’s readability, run the workflow against a test table, and sign off once the exported file matches the source records one-to-one.