Pranit Sherkar

12/01/2022, 1:52 PM
One thing I am stuck with Cloud deployment is that , I have a json file for bigquery auth of service account. On local I have set that variable pointing to file path, which works well and connects to big query, but on cloud deployment how can I make it work? Is there a way I can upload a creds file and then set up a deployment variable for GOOGLE_AUTH? Let me know

Sean Lopp

12/02/2022, 3:35 PM
Adding some context from our DMs: We attempted: There isn't currently a way to add a file to serverless that is outside of your Git repo. However, it appears Google clients will work if you translate the values from the JSON file into an environment variable that points at a JSON string. So you could do this:
  "type": "service_account",
  "project_id": "elementl-dev",
Then in your code you use:
client = bigquery.Client()
And then in Dagster Cloud you'd create the
environment variable following But the result was: It says ,
Please set GOOGLE_APPLICATION_CREDENTIALS or explicitly create credentials and re-run the application
Which I did as well but it shows the json keys in project and doesnrt deploy


12/02/2022, 3:38 PM
Could you add the file within a pre install shell script?