<@ULVA73B9P> when trying to load a dbt CLI profile...
# ask-marvin
j
@Marvin when trying to load a dbt CLI profile block, it fails due to a validation error. No other details are given, it just says to pass False to the validate parameter. What causes this?
n
hi @Jack Goslin - there is no other stack trace? can you paste what you get back here?
j
Copy code
Traceback (most recent call last):
  File "/Users/jack.goslin/Projects/dbt_core/venv/lib/python3.12/site-packages/prefect/blocks/core.py", line 841, in load
    return cls._from_block_document(block_document)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/jack.goslin/Projects/dbt_core/venv/lib/python3.12/site-packages/prefect/blocks/core.py", line 639, in _from_block_document
    block = block_cls.parse_obj(block_document.data)
            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/jack.goslin/Projects/dbt_core/venv/lib/python3.12/site-packages/pydantic/v1/main.py", line 526, in parse_obj
    return cls(**obj)
           ^^^^^^^^^^
  File "/Users/jack.goslin/Projects/dbt_core/venv/lib/python3.12/site-packages/prefect/blocks/core.py", line 265, in __init__
    super().__init__(*args, **kwargs)
  File "/Users/jack.goslin/Projects/dbt_core/venv/lib/python3.12/site-packages/pydantic/v1/main.py", line 341, in __init__
    raise validation_error
pydantic.v1.error_wrappers.ValidationError: 2 validation errors for DbtCliProfile
target_configs -> type
  field required (type=value_error.missing)
target_configs -> schema
  field required (type=value_error.missing)

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/Users/jack.goslin/Projects/dbt_core/projects/goodhouse/goodhouse.py", line 19, in <module>
    dbt_profile = DbtCliProfile.load('dbt-profile-goodhouse').get_profile()
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/jack.goslin/Projects/dbt_core/venv/lib/python3.12/site-packages/prefect/utilities/asyncutils.py", line 309, in coroutine_wrapper
    return call()
           ^^^^^^
  File "/Users/jack.goslin/Projects/dbt_core/venv/lib/python3.12/site-packages/prefect/_internal/concurrency/calls.py", line 432, in __call__
    return self.result()
           ^^^^^^^^^^^^^
  File "/Users/jack.goslin/Projects/dbt_core/venv/lib/python3.12/site-packages/prefect/_internal/concurrency/calls.py", line 318, in result
    return self.future.result(timeout=timeout)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/jack.goslin/Projects/dbt_core/venv/lib/python3.12/site-packages/prefect/_internal/concurrency/calls.py", line 179, in result
    return self.__get_result()
           ^^^^^^^^^^^^^^^^^^^
  File "/opt/homebrew/Cellar/python@3.12/3.12.4/Frameworks/Python.framework/Versions/3.12/lib/python3.12/concurrent/futures/_base.py", line 401, in __get_result
    raise self._exception
  File "/Users/jack.goslin/Projects/dbt_core/venv/lib/python3.12/site-packages/prefect/_internal/concurrency/calls.py", line 389, in _run_async
    result = await coro
             ^^^^^^^^^^
  File "/Users/jack.goslin/Projects/dbt_core/venv/lib/python3.12/site-packages/prefect/client/utilities.py", line 100, in with_injected_client
    return await fn(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/Users/jack.goslin/Projects/dbt_core/venv/lib/python3.12/site-packages/prefect/blocks/core.py", line 857, in load
    raise RuntimeError(
RuntimeError: Unable to load 'dbt-profile-goodhouse' of block type None due to failed validation. To load without validation, try loading again with `validate=False`.
Screenshot 1 is the block it's pulling. Screenshot 2 is the target config. The traceback seems like it's failing because of a missing schema but it's
(Optional)
in the block, and I do have the Type field filled out even though it's
(Optional)
as well