I was working on a dash app that required password access and had different levels of access and I decided to manage that using SQL. Since I was hosting it on Google Cloud Platform, it made sense to use big query to make that happen. Also, big query is extremely cheap (in contrast to cloud SQL) and would be practically free for this purpose (so far, they haven't charged me!)
Before we go to the coding part, we need to set up a google cloud platform account and create a database in big query. I followed the steps on
this video . It was very useful but some things changed on the configuration of big query,
specifically on the .json
of the key. What worked for me was following the same steps highlight by the video and to get the missing part, you have to
go to PIs&Services
menu and click on Credentials
. In the section Service Accounts
click on the service you have just created and then in theKEYS
tab then in ADD KEYS
. Choosse json as the format and download it (it will probably start downloading automatically).
You should put this json on your assets folder.