Fellow Dagsters!
We got Dagster running in a Kubernetes Cluster. One project has a sensor that looks for changes in a Google Sheet. On the local machine, I used a service account file for authentication. In the cloud, the service account doesn't work, and I don't know what to use instead to authenticate. The available methods for the pygsheets Python module are:
client secret
service account
service_account_env_var (Use an environment variable to provide service account credentials)
credentials_directory– Location of the token file created by the OAuth2 process. Use ‘global’ to store in global location, which is OS dependent. Default None will store token file in current working directory. Please note that this is override your client secret.
custom_credentials–A custom or pre-made credentials object. Will ignore all other params.
scopes–The scopes for which the authentication applies.
If anyone can even point me in the right direction, I would be grateful.