@Marvin I’m getting

Encountered exception during execution: RuntimeError("Unable to load 'dbt-profile' of block type 'dbt-cli-profile' due to failed validation. To load without validation, try loading again with `validate=False`.")
pydantic_core._pydantic_core.ValidationError: 1 validation error for DbtCliProfile
target_configs.type
  Field required [type=missing, input_value={'schema': 'target', 'thr...4', 'username': 'dbt'}}}, input_type=dict]

Only in the prefect cloud. When I run this locally DBT runs

It seems you're encountering a validation error when trying to load a

dbt-profile

of block type

dbt-cli-profile

in Prefect Cloud. This issue doesn't occur locally, which suggests it might be related to how the profile is being validated or configured in the cloud environment. Here are some steps and considerations that might help: 1. Validation Issue: The error message indicates that a required field, likely within

target_configs

, is missing. Ensure that your configuration in Prefect Cloud matches what you have locally, including any environment variables or secrets. 2. Profiles Directory: Make sure the

profiles_dir

is correctly set. If not specified, Prefect will use the

DBT_PROFILES_DIR

environment variable. If this variable is unset, it defaults to

$HOME/.dbt/

. Ensure this path is accessible in your cloud environment. 3. Environment Variables: If your

profiles.yml

uses environment variables, ensure that these are correctly set in Prefect Cloud. Prefect Secret blocks can be used for this purpose. 4. Prefect Blocks: If you're using Prefect blocks like the Snowflake Connector block, ensure these are properly configured to generate the

profiles.yml

as expected. 5. Documentation: Check the Prefect DBT integration documentation for more detailed examples and guidance on setting up DBT profiles with Prefect. If the problem persists, you might want to consider reaching out to the Prefect community or support for more tailored assistance.