[CT-2758] [Epic] Multi-project collaboration - Milestone 3

[MichelleArk]

Discussions:

• Multi-project collaboration #6725

Namespacing

Beta Give feedback

1. [CT-2944] [Bug] Ambiguous reference error for tests when model name is duplicated across packages #8327
   bug multi_project semantic +3
   

Contracts

Beta Give feedback

1. [CT-2814] [Feature] Better error message when a column in a contracted model is missing a data_type #8070
   enhancement model_contracts multi_project +3
   
2. [CT-3145] [Bug] partial parsing issue when adding private models to a new group #8697
   High Severity backport 1.6.latest bug +3
   
3. [CT-2810] [CT-2775] [Feature] Show contracts in project's dbt docs site dbt-docs#433
   enhancement multi-project +2
   
4. [CT-2857] Model contracts: raise warning for numeric types without specified scale #8183
   Impact: Adapters enhancement model_contracts multi_project paper_cut +5
   
5. [CT-2460] [Feature] Infer schema from prod, to enforce contract & detect breaking changes in dev #7432
   Refinement enhancement model_contracts multi_project spike state +6
   
6. [CT-2126] [Spike] Enforce model contracts for python models #6984
   model_contracts multi_project spike stale +4
   
7. [CT-2625] Support model contracts + constraints with nested fields in core #7759
   model_contracts multi_project tech_debt +3
8. [CT-2774] Optional type aliasing for model contract data_type #8007
   enhancement model_contracts multi_project +3
   
9. [CT-2782] [Bug] Error - cannot reference permanent table from temporary table constraint when running incremental model with a foreign key #8022
   Impact: Adapters Medium Severity backport 1.5.latest backport 1.6.latest bug model_contracts multi_project +7
   
10. [CT-2910] [Mesh] Restructure ContractBreakingChangeError message to explicitly list breaking changes #8282
    model_contracts multi_project +2
    
11. [CT-2809] Support ref in foreign key constraint expressions #8062
    enhancement model_contracts multi_project paper_cut +4
12. [CT-2897] [Feature] Suppress stack trace when a model contract is violated #8266
    enhancement model_contracts multi_project +3
13. [CT-2787] [Bug] dbt is too aggressive about preventing contracted changes during CI #8028
    model_contracts multi_project +2
    
14. [CT-2969] [ModelGov3] Turn "Breaking Change to Contract" into warning, unless model is versioned #8384
    enhancement model_contracts model_versions +3
    
15. [CT-3206] Add warning_tag to UnversionedBreakingChange #8827
    model_contracts +1

Versioning

Beta Give feedback

1. [CT-2832] [Spike] Can the hook for latest model version unsuffixed view/clone leverage our clone macro/materialization? #8126
   model_versions multi_project spike +3
   
2. [CT-2468] [Feature] For versioned models, automatically create view/clone of latest version in unsuffixed database location #7442
   enhancement model_versions multi_project +3
3. [CT-2592] Statically parse version keyword argument in ref #7688
   model_versions multi_project tech_debt +3
   
4. [CT-2861] [Bug] Changing the latest_version of a versioned model should mark all unpinned refs as state:modified #8189
   backport 1.6.latest bug multi_project +3
   
5. [CT-3067] [Bug] Docs blocks don't work in model versions #8540
   backport 1.5.latest backport 1.6.latest bug +3
   

Groups & access

Beta Give feedback

1. [CT-2578] [Feature] Hierarchical access config in dbt_project.yml #7619
   enhancement model_groups_access multi_project +3
   
2. [CT-2968] [ModelGov3] Allow access to be set as config, including in dbt_project.yml #8383
   enhancement model_groups_access +2
   
3. [CT-2889] Macros executed via run-operation cannot ref private models #8248
   enhancement help_wanted model_groups_access multi_project +4
4. [CT-2963] [Bug] CI breaking when a group is changed #8371
   Impact: Orch backport 1.5.latest backport 1.6.latest bug model_groups_access +5
   
5. [CT-2619] [Feature] Group and access configuration for sources and exposures #7750
   enhancement model_groups_access multi_project +3
6. [CT-3527] [implementation] extend access and groups to exposures & source #9339
   enhancement model_groups_access multi_project user docs +4

Adapters

Beta Give feedback

1. [ADAP-637] [Feature] Follow-up to nested fields #738 and #673 - Allow array of struct dbt-bigquery#781
   enhancement +1
   
2. [ADAP-383] [Feature] Support Dynamic Data Masking in CTAS Statements dbt-adapters#85
   enhancement +1
3. [CT-2957] [Bug] Cannot specify column contract of type UUID in PostgreSQL with DBT 1.5.3 dbt-postgres#54
   Medium Severity bug +2