depends_on syntax use for Upstream model

In-Depth Discussions
1

I have a problem. I need to use upstream target (Fact) table to know the latest date data entry. I want to use that information in Downstream Staging table. I tried to use depends_on clause in Downstream model but it is not working.

1. I used depends_on as this in the config block:

{{ config(

tags=\["blah", "blah blah"\],

snowflake_warehouse='awesome_warehouse',

depends_on: {{ ref(‘upstream_parent_model’) }}

) }}

It did not work.

2. Then I used the same in the beginning of the model code :

{{ config(

tags=\["blah", "blah blah"\],

snowflake_warehouse='awesome_warehouse'

) }}

depends_on: {{ ref(‘upstream_parent_model’) }}

with campaign as (

    select…. blah blah

It did not work.

Do you know? where do i place depends_on code snippet in the model sql ?

Best

sobhan

2

By the way I do not know how that forward slash appear in the post

{{ config(

tags=[“blah”, “blah blah”],

snowflake_warehouse=‘awesome_warehouse’,

depends_on: {{ ref(‘upstream_parent_model’) }}

) }}