Skip to main content

​
prefect_dbt.cli.configs.snowflake

Module containing models for Snowflake configs

​
Classes

​
SnowflakeTargetConfigs

Target configs contain credentials and settings, specific to Snowflake. To find valid keys, head to the Snowflake Profile page. Attributes:
  • connector: The connector to use.
Examples: Load stored SnowflakeTargetConfigs: 
from prefect_dbt.cli.configs import SnowflakeTargetConfigs

snowflake_target_configs = SnowflakeTargetConfigs.load("BLOCK_NAME")
Instantiate SnowflakeTargetConfigs. 
from prefect_dbt.cli.configs import SnowflakeTargetConfigs
from prefect_snowflake.credentials import SnowflakeCredentials
from prefect_snowflake.database import SnowflakeConnector

credentials = SnowflakeCredentials(
    user="user",
    password="password",
    account="account.region.aws",
    role="role",
)
connector = SnowflakeConnector(
    schema="public",
    database="database",
    warehouse="warehouse",
    credentials=credentials,
)
target_configs = SnowflakeTargetConfigs(
    connector=connector,
    extras={"retry_on_database_errors": True},
)
Methods:

​
get_configs 

get_configs(self) -> Dict[str, Any]
Returns the dbt configs specific to Snowflake profile. Returns:
  • A configs JSON.

​
handle_target_configs 

handle_target_configs(cls, v: Any) -> Any
Handle target configs field aliasing during validation