Problema criando um model novo
Opened this issue · 0 comments
FelipeSBarros commented
Estou encontrando erro ao seguir o tutorial do BDT.
A principio o projeto seria com BigQuery. Mas eu estou usando postgres. Imagino ser esse o problema.
Nesta parte apresenta como criar um model novo.
Fiquei sem entender se a parte:
from `dbt-tutorial`.jaffle_shop.customers
- Deve estar com aspas simples o com o acento usado na página do tutorial?
- Se "dbt-tutorial" é referente ao nome da pasta onde o projeto se encontra. Se for assim, eu devo mudar para "DBT_tutorial";
Ao rodar o dbt run
, tenho o seguinte treceback:
03:21:49 Running with dbt=1.3.0
03:21:49 Found 3 models, 4 tests, 0 snapshots, 0 analyses, 289 macros, 0 operations, 0 seed files, 0 sources, 0 exposures, 0 metrics
03:21:49
03:21:49 Concurrency: 1 threads (target='dev')
03:21:49
03:21:49 1 of 3 START sql view model public.customers ................................... [RUN]
03:21:49 1 of 3 ERROR creating sql view model public.customers .......................... [ERROR in 0.09s]
03:21:49 2 of 3 START sql table model public.my_first_dbt_model ......................... [RUN]
03:21:50 2 of 3 OK created sql table model public.my_first_dbt_model .................... [SELECT 2 in 0.14s]
03:21:50 3 of 3 START sql view model public.my_second_dbt_model ......................... [RUN]
03:21:50 3 of 3 OK created sql view model public.my_second_dbt_model .................... [CREATE VIEW in 0.06s]
03:21:50
03:21:50 Finished running 2 view models, 1 table model in 0 hours 0 minutes and 0.44 seconds (0.44s).
03:21:50
03:21:50 Completed with 1 error and 0 warnings:
03:21:50
03:21:50 Database Error in model customers (models/customers.sql)
03:21:50 syntax error at or near "`"
03:21:50 LINE 11: from `dbt-tutorial`.jaffle_shop.customers
03:21:50 ^
03:21:50 compiled Code at target/run/jaffle_shop/models/customers.sql
03:21:50
03:21:50 Done. PASS=2 WARN=0 ERROR=1 SKIP=0 TOTAL=3