Implementation:Astronomer Astronomer cosmos SnowflakeEncryptedPrivateKeyEnvProfileMapping
| Knowledge Sources | |
|---|---|
| Domains | Profile_Mapping, Snowflake |
| Last Updated | 2026-02-07 17:00 GMT |
Overview
Concrete tool for mapping Airflow snowflake connections to dbt snowflake profiles provided by astronomer-cosmos.
Description
The SnowflakeEncryptedPrivateKeyEnvProfileMapping maps an Airflow snowflake connection to a dbt snowflake profile. It translates connection parameters (host, login, password, schema, port, extras) into the YAML structure that dbt expects in `profiles.yml`. This variant passes an encrypted private key via an environment variable.
Usage
Use this profile mapping when configuring Cosmos to run dbt commands against a Snowflake backend. Assign it to `ProfileConfig(profile_mapping=...)` when the target Airflow connection uses the `snowflake` connection type and authentication is performed with an encrypted private key supplied through an environment variable.
Code Reference
Source Location
- Repository: Astronomer_Astronomer_cosmos
- File: cosmos/profiles/snowflake/user_encrypted_privatekey_env_variable.py
Signature
class SnowflakeEncryptedPrivateKeyEnvProfileMapping(SnowflakeBaseProfileMapping):
airflow_connection_type: str = "snowflake"
dbt_profile_type: str = "snowflake"
Import
from cosmos.profiles.snowflake import SnowflakeEncryptedPrivateKeyEnvProfileMapping
I/O Contract
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| conn_id | str | Yes | Airflow connection ID for Snowflake |
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.snowflake import SnowflakeEncryptedPrivateKeyEnvProfileMapping
profile_config = ProfileConfig(
profile_name="default",
target_name="dev",
profile_mapping=SnowflakeEncryptedPrivateKeyEnvProfileMapping(conn_id="snowflake_default"),
)