Establishing Mesh Across Warehouses (BQ upstream -> RedShift downstream)

Help
1

I’m trying to connect my downstream RedShift project to an upstream BigQuery one. Both reside in the same Enterprise+ instance and I’ve configured all the things according to documentation. I’m getting the following error in my RedShift (downstream) project. Encountered an error:
Runtime Error
Could not resolve the dependency on project named ‘analytics_bigquery’ in dependencies.yml
The cause of this error could be:

  • The project name ‘analytics_bigquery’ is misspelled in dependencies.yml

  • The upstream project ‘analytics_bigquery’ has not had a successful run in its Staging or Production environment

  • There are multiple projects named ‘analytics_bigquery’ in this dbt Cloud account.

    When I remove the dependencies.yml (# dependencies.yml
    projects: - name: analytics_bigquery) from my RedShift project no more errors.
    Any help or additional documentation is great appreciated.
    Thanks in advance

2

As far as I’m aware of - connecting a downstream and upstream projects of different warehouse platforms (bq, redshift, etc) isn’t a thing.

Note: @Jeremy Yeo originally posted this reply in Slack. It might not have transferred perfectly.