# Does {{ ref () }} has any limitations?

**URL:** <https://discourse.getdbt.com/t/does-ref-has-any-limitations/11509>\
**Category:** Help\
**Created:** [January 11, 2024, 12:19pm UTC](https://discourse.getdbt.com/t/does-ref-has-any-limitations/11509 "2024-01-11T12:19:28Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![catarina.ribeiro](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/catarina.ribeiro/32/1314_2.png) [@catarina.ribeiro](https://discourse.getdbt.com/u/catarina.ribeiro)\
**Post date:** [January 11, 2024, 12:19pm UTC](https://discourse.getdbt.com/t/does-ref-has-any-limitations/11509/1 "2024-01-11T12:19:28Z")

</div>

I have a view model with multiple union all of different sources data.  
Let’s call it` "v_combined_data"`

Then there is a table model named `"fact_sales_transactions"` that uses this view.  
In this model, I do a simple select from` {{ref ('v_combined_data') }}` which should already indicate there’s an order to execute this

However, there is a job running every day, and sometimes the table does not get all the data from the view model. The view has the correct data, but the table is incomplete. When I run the job manually again, without changing anything at all, the data gets completed.

**Here’s what I already did**

- We use the `ref` function correctly.

- I analysed the DAG graph and it seems correct.

- I added the following comment to the beginning of the .sql model ([Forcing Dependencies -- depends\_on example code](https://discourse.getdbt.com/t/forcing-dependencies-depends-on-example-code/3558))  
`-- depends on: {{ ref('v_combined_data') }}`

- The job commands’ list executes first the view and then the next command is to execute the table.

Does anyone have any idea why this might be happening?

NOTE: I noticed that this dbt project does not have a schema.yml set up, could this be a reason for this to happen?