[CT-3315] [Bug] Selecting nodes downstream of upstream public models for run/build/test/etc

[jtcohen6]

Is this a new bug in dbt-core?

• I believe this is a new bug in dbt-core
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

Currently, I can use these selection criteria for listing nodes downstream of upstream public models:

dbt list -s upstream_project_name+
dbt list -s package:upstream_project_name+
dbt list -s upstream_project_name.public_model+

This correctly lists the public model(s) available from upstream_project_name, as well as the nodes in my own project that depend on them (via cross-project ref).

But I cannot use the same selection to actually execute (build/run/test/etc) the downstream nodes in my own project:

dbt build -s upstream_project_name+
dbt build -s package:upstream_project_name+
dbt build -s upstream_project_name.public_model+

Expected Behavior

I can select the nodes downstream of upstream project / public models - for listing and execution

Steps To Reproduce

Have a downstream project with cross-project references to public models in an upstream project (I'm using dbt-labs/snowflake-tpcds-sales-spoke)

Relevant log output

$ dbt ls -s snowflake_tpcds_core+
Sending project to dbt cloud
Successfully created task with id f87075c0-baf2-4abe-8562-68ae84cdacbd
Waiting for response

15:02:05 Running with dbt=1.6.6
15:02:06 Registered adapter: snowflake=1.6.4
15:02:06 Found 19 models, 30 tests, 14 sources, 0 exposures, 0 metrics, 489 macros, 0 groups, 0 semantic models
15:02:06 snowflake_tpcds_core.call_centers
15:02:06 snowflake_tpcds_core.customers
15:02:06 snowflake_tpcds_core.stores.v1
15:02:06 snowflake_tpcds_core.stores.v2
15:02:06 snowflake_tpcds_sales_spoke.marts.transactions
15:02:06 snowflake_tpcds_sales_spoke.marts.not_null_transactions_transaction_id
15:02:06 snowflake_tpcds_sales_spoke.marts.unique_transactions_transaction_id

Invocation has finished
Artifacts have been downloaded
11:02:11 ~/dev/scratch/snowflake-tpcds-demo/snowflake-tpcds-sales-spoke (jerco/add-transactions-filter *%) $ dbt build -s snowflake_tpcds_core+
Sending project to dbt cloud
Successfully created task with id 94aaed50-b8f0-4b08-abda-49b92fe9e8b1
Waiting for response

15:02:20 Running with dbt=1.6.6
15:02:21 Registered adapter: snowflake=1.6.4
15:02:21 Found 19 models, 30 tests, 14 sources, 0 exposures, 0 metrics, 489 macros, 0 groups, 0 semantic models
15:02:21 The selection criterion 'snowflake_tpcds_core+' does not match any nodes
15:02:21 Nothing to do. Try checking your model configs and model specification args

Invocation has finished
Artifacts have been downloaded

Environment

- dbt Cloud CLI + IDE :)
- dbt: 1.6.x

Which database adapter are you using with dbt?

snowflake

Additional Context

No response