Jump to content

Connect Leeroopedia MCP: Equip your AI agents to search best practices, build plans, verify code, diagnose failures, and look up hyperparameter defaults.

Implementation:Astronomer Astronomer cosmos GoogleCloudServiceAccountFileProfileMapping

From Leeroopedia


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

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"),
)

Related Pages

Page Connections

Double-click a node to navigate. Hold to expand connections.
Principle
Implementation
Heuristic
Environment