Clean tables on Google Sheets and upload data to Cloud DB as tables by using Python Script
Description
Process of structuring, enriching and delivering data points on excel sheets to tables on our Big Query instance (GCP) by leveraging a Google Sheet add-on called “Owox” that enables bi-direcctional communication between our G-sheet book and the assigned Cloud Data Base.
Child issues
XDP-27
Collect all Related Data Frame into G-sheets within Google Drive
To Do
XDP-28
Wrangle and perform action to Clean Tables
To Do
XDP-29
Create Python Script to grab Gsheets from Drive Folder, convert them into pandas Data Frames
Done
XDP-30
Make the script to Establish connection with Big Query and send the data frames as Tables
Done
Activity
Show:
Details
Priority
Medium
Created: 30 May 2022, 23:53
Updated:
5 June 2022, 05:02