Description

At the moment, Lightdash doesn't recognise the Bigquery oauth credentials inside the Google Cloud Build.

CLI error: Cannot get credentials from oauth

profiles.yml example

main:
  outputs:    
    dev:
      type: bigquery
      method: oauth
      dataset: "default"
      threads: 1
      location: EU

The difference between dbt and Lightdash is that dbt only needs to access at that moment while Lightdash needs to store the credentials to be used later, when users run queries in the Lightdash UI.

What problem does this solve?

Run Lightdash commands in Google Cloud CI/CD. eg: lightdash start-preview

Workaround

Use the service account method in dbt profile.