FelipeSBarros/DBT_tutorial

Problema criando um model novo

Opened this issue · 0 comments

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