Category "dbt"

SQL-how can i product/ multiply across partitions with window functions

The input I have is composed of the following columns: time, UseID, and value. I want to get the plt column as the product of successive numbers. I know about t

dbt depends on a source not found

Could you please help me with this issue? Encountered an error: Compilation Error in model metrics_model (models\example\metrics_model.sql) Model 'model.test_

Storing the results from run query into a table in dbt

I am calling this store procedure in dbt. How do I store the results using a select statement into a temp table? {% set results= run_query('call mystoredproc()'

Using variable arrays in models

Is it possible to define an array in the vars section and use it inside the SQL syntax of a model? Something like this dbt_project.yml: vars: active_country_c

Operator to concatenate two dbt Jinja sets?

In a given model, I am using two macros to create sets for a later loop. Adapting the example from the docs, it looks something like this: {% set pay_1 = ["bank

Managing DBT profile file in MWAA

I would like to use DBT in MWAA Airflow enviroment. To achieve this I need to install DBT in the managed environment and from there run the dbt commands via the