The error Database Error in model section2 (models\example\section2.sql) column "section1" does not exist LINE 9: FROM ref( section1 ) S1 ^ My project directory /dbtxyz/models/example/section1.sql /dbtxyz/models/example/section2.sql /dbtxyz/project.yml /dbtxyz/profile.yml My profile.yml default: outputs: dev: type: "postgres" host: "localhost" user: "postgres" password: "password" port: 5432 dbname: "myprojectdata" schema: "myprojectdataschema" target: "dev" My project.yml analysis-paths: – analyses clean-targets:… Read More dbt treats referenced tables like columns and says they don't exist

sorry, I’m very new to dbt, just trying to learn and cant figure out why cant I connect to snowflake. I was able to connect to postgresql database. Here’s my profiles.yml file, I think maybe user is not correct? I can’t seem to figure out what is what tbh. Thank you for any help. demo_dbt:… Read More dbt snowflake target doesn't seem to work

Is it possible/how would you go about displaying the query text that gets displayed inside Snowflake UI "history" tab inside of visual studio terminal? I current have a local dev env (docker) that I use to write dbt (https://www.getdbt.com/) locally with and I can execute on against snowflake. The syntax is different in dbt than… Read More Display Query Text from Snowflake inside Visual Studio, apart of Error (when executing dbt)?

I have a query that selects some data that I would like to use to create an incremental table. Something like: {{ config( materialized=’incremental’, unique_key=’customer_id’ ) }} SELECT customer_id, email, updated_at, first_name, last_name FROM data The input data has duplicate customers in it. If I read the documentation correctly, then records with the same unique_key… Read More How to use dbt's incremental model without duplicates

with uuid_generation AS (select uuid_string() as uuid) select metadata$filename, to_timestamp_ntz(current_timestamp()), md.$1 from @S3/table/prod/ (file_format => STG.XML, pattern =>’^((?!archive).)*$’) md cross join uuid_generation This snippet works perfectly fine in snowflake (dbeaver). However, when I put it in a dbt model, I get this error: Missing column specification I also tried this: with uuid_generation AS (select uuid_string()… Read More dbt: Missing column specification

In DBT YAML file such as dbt_project.yml, what is + or – sign of the element? models: # Be sure to namespace your model configs to your project name dbt_labs: # This configures models found in models/events/ events: +enabled: true # <— What is the meaning of +? +materialized: view # <— What is the… Read More dbt – what is +/- in YAML files?