How to do this with existing HA SQLite database 

have you tried to transfer the existing database to BigQuery? Are there any existing workflows that I can utilize and not re-invent the wheel? even if you can point me to some external resources, that would be of great help. Thank you! 