Error when using service account json key file from secrets manager in dbt cloud build pipeline step
I’m running a cloud build pipeline to deploy my dbt data pipelines project. In one of the steps I’m trying to execute dbt compile which tests a connection to BigQuery. I get the error: dbt was unable to connect to the specified database. The database returned the following error: Database Error Invalid control character at: line 1 column 174 (char 173). The credentials are being accessed from google cloud secrets manager. Here is my cloudbuild.yaml file: