Incremental model fails when promoted to Prod for the first time

Help
1

I’m facing an issue with our PSA and Raw Vault layers. We’ve added a new Satellite table that appends data from the PSA layer. However, when we push it to production, I encounter the following error:

Database Error in model link_rf_customer_account (models/raw_vault_rebuild/link/link_rf_customer_account.sql)
002003 (42S02): SQL compilation error: Object 'DATAVAULT_PROD.STAGING.PSA_STG_CUSTOMER_ACCOUNT' does not exist or you are not authorized.

Any help on resolving this would be appreciated!

The context of why I’m trying to do this

What I’ve already tried : It worked when i tried the following: dbt build -s +link_rf_customer_account --full-refresh

I would like to learn why did that happen and how to prevent this in future.

Some example code or error messages

Put code inside backticks
  to preserve indentation
    which is especially important 
      for Python and YAML!