I would like to declare and init a variable in a dbt model customer.sql file. I used the keyword DECLARE to declare a variable like the BigQuery documentation suggests but I got a Syntax error on D...

I'm trying to determine how I can conditionally set schema config attributes. I've attempted this by a macro in both dbt_project.yml and also in schema.yml but both of these methods fail with: 00:2...

dbt's built in docs is amazing for tracking data lineage, data dictionaries, business rules etc. But publishing these docs to a central place in a secure way without using dbt Cloud is proving to b...

Is there an easy way to write a test for a column being positive in dbt? accepted_values doesn't seem to work for continuous variables. I know you can write queries in ./tests but it looks like an ...

I use SQLFluff to ensure a uniform syntax in the company and reduce error warnings before running the models in dbt. Since our syntax does not completely match the syntax of SQLFluff I would like t...

I have a Snowflake account that uses MFA. Logging in to Snowflake promtps for the MFA and I receive a push notification on my phone. Approving that logs me in. When setting up DBT Cloud it asks for...

I would like to use dbt (Data build tool) in one of my project. I am facing hurdle while creating a project or using DBT command. I have completed the installation process as described on DBT web...

I'm trying to connect to snowflake via dbt but connections fail with the error below: Using profiles.yml file at /home/myname/.dbt/profiles.yml Using dbt_project.yml file at /mnt/c/Users/Public/lea...

For incremental models, the DBT documentation here says: The unique_key should be supplied in your model definition as a string representing a simple column or a list of single quoted column names...

I started to migrate some of your transformations jobs to DBT. As you can see on the image bellow, there is usually 1 to 2 transformations before to have our final table (up to 5 transformations in...

When running dbt with descendants, I would like to exclude two models. I can exclude one model like so: dbt run ga4_update_set+ --exclude nz_daily_cohorts The above works as expected. I tried the ...

Hi I am trying to define a select statement in a set variable in dbt, can any one suggest how to set sql query as a variable in dbt and how to access those variables in below CTEs?

I have a DBT package named dbt_helpers, where i intend to override some of dbt's in built global macros. In this example i intend to override the macro dbt_spark_validate_get_file_format, which is ...

I am trying to set a date variable within a dbt model to be the date 7 days ago. The model will run against a Redshift database. I have done the following to set the variable, however I get the err...

I have a DBT project, and a python script will be grabbing data from the postgresql to produce output. However, part of the python script will need to make the DBT run. I haven't found the library ...

Is there a way to check what packages are installed? I would expect something like dbt list packages? The context is: Until I run dbt deps the content of packages.yml gives me nothing. And there a...

I want to create an empty table with specific columns and data types, I don't have any reference table from where I can do SELECT * FROM . The following link has an image which I intend to do Pleas...

My aim is to be able to have "dynamic" sources depending on the type of DBT run I am doing. To be more precise, I am trying to find a solution to perform end-to-end business testing of ou...

I'm new to dbt, I am successfully able to create my models and schemas and macros, but when I do dbt docs generate I get manifest.json, but not catalog.json and so dbt docs serve is failing. It thr...

I've been considering turning on Databricks Unity Catalog in our primary (only) workspace, but I'm concerned about how this might impact our existing dbt loads with the new three-part object refere...

connection to dbt and snowfalke was successful but when tried to run this command: $ dbt run it gives this error ERROR: Runtime Error Could not find profile named 'learn_dbt' Encountered an error...

We've been using Snowflake+DBT with key pair authentication for a long time now, and we've never had any issues. Recently, we started getting random connection errors on some models: 250001 (08001)...

I’m trying to make one model in dbt depend on another (trying to run the second model after the first one is completely finished), but I’m confused, when to use ref() or source()? What is the diffe...

I keep getting the error below when I use dbt run - I can't find anything on why this error occurs or how to fix it within the dbt documentation. [WARNING]: Did not find matching node for patch wit...

I'm trying to select the latest partition from a BigQuery table without scanning the whole table in a DBT model in order to save query costs. DBT doesnt allow using semicolons in a data model so us...