请帮我解决这个问题:下面是我的源定义在schema.yml以下(以及其他两个型号)-->;
sources:
- name: src_pizzas
database: test_db
schema: pizza
tables:
- name: src_sqlserver_pizzas
columns:
- name: size
description: "The size of the pizza"
- name: price
.......
然后,我将这个模型放在Models/Example目录下,名称为tsnfrmed_sqlserver_pizzas.sql:
{{ config(materialized='view') }}
SELECT
UPPER(size) AS size,
UPPER(price) AS price,
UPPER(pizza_id) AS pizza_id,
UPPER(pizza_type_id) AS pizza_type_id
FROM {{ source('src_pizzas', 'src_sqlserver_pizzas') }}
现在当我 run 的时候-->;
dbt run --select "tsnfrmed_sqlserver_pizzas"
我得到了下面的错误(表名和连接都很好,因为我有其他模型在连接,我不能排除这里有打字错误的问题):
Model 'model.pizza_data.tsnfrmed_sqlserver_pizzas' (models\example\tsnfrmed_sqlserver_pizzas.sql) depends on a source named 'pizza.src_sqlserver_pizzas' which was not found