Add default `bigquery` output to `transform/profile/profiles.yml`

Like we have default outputs for snowflake and postgres in https://gitlab.com/meltano/files-dbt/-/blob/master/bundle/transform/profile/profiles.yml, we should add one for bigquery now that we have meltano#2479 (closed).

Like target-bigquery does, we would use Service Account File Authentication: https://docs.getdbt.com/reference/warehouse-profiles/bigquery-profile/#service-account-file-authentication