You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi, I'm using dbt for ETL project, and having difficult for building models.
I wrote staging files in /staging/my_data_type/v1.sql, /staging/my_data_type/v2.sql
and I want to aggregate those multiple sqls in a single intermediate sql, /intermediate/my_data_type.sql using ref() function.
however, dbt's node name is determined by file name, the full path is model.<dbt-project-name>.<file-name>
can I change this node name?
as a example, the desired output is,
node name: my_data_type__v1 for /staging/my_data_type/v1.sql, and my_data_type__v2 for /staging/my_data_type/v2.sql
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hi, I'm using dbt for ETL project, and having difficult for building models.
I wrote staging files in
/staging/my_data_type/v1.sql
,/staging/my_data_type/v2.sql
and I want to aggregate those multiple sqls in a single intermediate sql,
/intermediate/my_data_type.sql
usingref()
function.however, dbt's node name is determined by file name, the full path is
model.<dbt-project-name>.<file-name>
can I change this node name?
as a example, the desired output is,
node name:
my_data_type__v1
for/staging/my_data_type/v1.sql
, andmy_data_type__v2
for/staging/my_data_type/v2.sql
Beta Was this translation helpful? Give feedback.
All reactions