When working with dbt expectation getting this error:
Compilation Error in test expect_column_values_to_be_of_type_marketing_forecast_date__date (models\sources\spectrum\schema\marketing_forecast.yml)
05:46:39 ‘test_expect_column_values_to_be_of_type’ is undefined. This can happen when calling a macro that does not exist. Check for typos and/or install package dependencies with “dbt deps”.
# marketing_forecast.sql file
{{ config(materialized = "view") }}
select
tentpole,
to_date(date, 'M/d/yyyy') as date,
to_date(batch, 'M/d/yyyy') as batch,
industry,
cast(leads as integer),
cast(sqls as integer),
cast(opportunities as integer),
cast(demos as integer),
cast(customers as integer)
from {{ source('spectrum', 'marketing_forecast') }}
# marketing_forecast.yml file
version: 2
models:
- name: marketing_forecast
description: "Marketing forecast data"
columns:
- name: tentpole
tests:
- accepted_values:
values: ['POS Nation', 'Rain']
- name: date
tests:
- expect_column_values_to_be_of_type:
column_type: date
# packages.yml file
packages:
- package: dbt-labs/dbt_utils
version: 1.1.1
- package: dbt-labs/metrics
version: 1.5.0
- package: calogica/dbt_expectations
version: 0.10.1