Clarify users should run producer project in staging to resolve cross project ref

[mirnawong1]

Contributions

• I have read the contribution docs, and understand what's expected of me.

Link to the page on docs.getdbt.com requiring updates

We should clarify that dbt mesh fetches public model information from the producer's staging environment instead of production. the logic should fetch from staging if the consumer is in staging and from production if the consumer is in production.

For more context and details, refer to internal slack thread.

What part(s) of the page would you like to see updated?

https://docs.getdbt.com/docs/collaborate/govern/project-dependencies#how-to-write-cross-project-ref

https://docs.getdbt.com/guides/mesh-qs?step=1

Additional information

No response

[mirnawong1]

Mirna to review this and address