is there a way to make these warnings in DBT errors? [WARNING]: Did not find matching node for patch with name 'my_model' in the 'models' section of file 'models/path/to/model.yml' We check errors...

I am relatively new to DBT and I have been reading about env_var and I want to use this in a couple of situations and I am having difficultly and looking for some support. firstly I am trying to us...

I want to run a DBT Snapshot and am following a near-identical template to the one outlined in the documentation. However, I get the error when I run dbt snpashot Compilation Error in model test_sn...

Using the star macro, is there a way to also get the column data type (boolean, numerical, etc), in addition to the column name? For example, this query uses the star macro to collect the column na...

I have currently dockerized my DBT solution and I launch it in AWS Fargate (triggered from Airflow). However, Fargate requires about 1 minute to start running (image pull + resource provisioning + ...

I want to iterate over all the columns using dbt.

hope you are doing well. I wanted to check if anyone has get up and running with dbt in aws mwaa airflow. I have tried without success this one and this python packages but fails for some reason or...

I am trying to build a DBT model from SQL which has delete statements based on where clause. Can any one please suggest me how to convert the below SQL delete statement into DBT model? ''' delete t...

Having trouble running dbt today... encountered this error message and cannot debug the issue. I did not have this issue yesterday and have not changed anything since. Installed dbt with Homebrew R...

I need some wisdom for a new DBT use case that I am trying to solve. I am pretty new to DBT and not sure what is the most efficient DBT way. We are using snowflake as our DWH. Problem We have a lot...

When running dbt jobs in Meltano, dbt run jobs may collide with each other if run out of a triggered context - for instance, when an on-demand job collides with a scheduled job or a CI-based job. I...

I have been reading dbt's How we configure Snowflake guide which explains the rationale behind having a raw database and an analytics database. Raw data is loaded into your warehouse into raw (e.g....

I've been working with dbt for a couple of months now, so still fairly new to it. When running a test model, I have no problems when using the view materialization: {{ config(materialized='view') }...

We use airflow to orchestrate our workflows, and dbt with bigquery for our daily transformations in BigQuery. We have two separate git repos, one for our dbt project and a separate one for airflow....

I would like to be able to run an ad-hoc python script that would access and run analytics on the model calculated by a dbt run, are there any best practices around this?

We are considering using dbt to manage models in our PostgreSQL data warehouse. Since dbt models are SQL select statements, there doesn't seem to be an obvious, or documented, way to specify that a...

I'm a new user of dbt, trying to write a relationship test: - name: PROTOCOL_ID tests: - relationships: to: ref('Animal_Protocols') field: id I am getting this error: Compilation Error Invalid...

I'm just onboarding dbt and having gone through the tutorial docs I'm wondering if there's a difference between materializing my transformations as views or tables? I'm using Snowflake as the data ...

We have a large schema.yml file in our DBT folders. It is not the cleanest or easiest to find what we need in it. I am curious if anyone knows of a way to split up this file. I am not trying to ove...

I'm new to the dbt and I'm planning to use dbt cli. One question is how to setup the dbt ui and have such a data lineage graph? I didn't find how to do it here with cli https://docs.getdbt.com/tuto...

I am curious if I can pass macros into another macro like this: {% macro my_macro(a, b, another_macro) %} ... {{ another_macro(a,b) }} ... {% endmacro %} BONUS: If dbt's framework can allow it ...

Thank you in advance for helping me in my journey! I am a dbt newb, doing the dbt fundamentals course. I am following the directions exactly. Sequence of the issue: I created .sql files in my mode...

I'm trying to build a model in DBT that flattens out a struct with name properties that contains about a hundred structs inside it (e.g. property1, property2, etc.), each with 5 different columns o...

It seems dbt only works for a single database. If my data is in a different database, will that still work? For example, if my datalake is using delta, but I want to run dbt using Redshift, would d...

can anyone share how to organise multiple projects in dbt , given the best practices. My present abstract architecture hierarchy is as follows Analytics --.dbt/ -----profiles.yml --projects/ -----...