Implementation:Astronomer Astronomer cosmos GoogleCloudServiceAccountFileProfileMapping
| Knowledge Sources | |
|---|---|
| Domains | Profile_Mapping, BigQuery |
| Last Updated | 2026-02-07 17:00 GMT |
Overview
Concrete tool for mapping Airflow google_cloud_platform connections to dbt bigquery profiles (service-account file method) provided by astronomer-cosmos.
Description
The GoogleCloudServiceAccountFileProfileMapping maps an Airflow google_cloud_platform connection to a dbt bigquery profile using the service-account authentication method. It reads the path to a service account JSON key file from the Airflow connection and passes it to the dbt profile as the `keyfile` parameter.
Usage
Use this profile mapping when configuring Cosmos to run dbt commands against a BigQuery backend with a service account key file on disk. Assign it to `ProfileConfig(profile_mapping=...)` when the target Airflow connection uses the `google_cloud_platform` connection type.
Code Reference
Source Location
- Repository: Astronomer_Astronomer_cosmos
- File: cosmos/profiles/bigquery/service_account_file.py
Signature
class GoogleCloudServiceAccountFileProfileMapping(BaseProfileMapping):
airflow_connection_type: str = "google_cloud_platform"
dbt_profile_type: str = "bigquery"
dbt_profile_method: str = "service-account"
Import
from cosmos.profiles.bigquery import GoogleCloudServiceAccountFileProfileMapping
I/O Contract
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| conn_id | str | Yes | Airflow connection ID for BigQuery (google_cloud_platform type) |
Outputs
| Name | Type | Description |
|---|---|---|
| profile | dict | dbt profile YAML dictionary |
| env_vars | dict | Environment variables for secret fields |
Usage Examples
from cosmos.config import ProfileConfig
from cosmos.profiles.bigquery import GoogleCloudServiceAccountFileProfileMapping
profile_config = ProfileConfig(
profile_name="default",
target_name="dev",
profile_mapping=GoogleCloudServiceAccountFileProfileMapping(conn_id="google_cloud_default"),
)