[CT-2831] [Epic] dbt-core 1.7 <> Semantic Layer

[jtcohen6]

Follow-ups, extensions, UX improvements, and bugs sourced from:

• New dbt Semantic Layer Spec Proposal #7456
• [CT-2520] [Epic] dbt-core 1.6 x MetricFlow Integration #7498
• internal notion doc

Features

Preview Give feedback

1. [CT-3090] Support properties for null value coalescing in metrics #8593
   Impact: CA backport 1.6.latest bug semantic +4
   
2. [CT-3091] Add SavedQuery node #8594
   Impact: CA Impact: SL semantic +3
   
3. [CT-3092] Support optional label property for semantic layer objects #8595
   Impact: SL semantic +2
   

Bugs & consistency

Preview Give feedback

1. [CT-2731] Semantic Models should be able to reference sources #7934
   enhancement semantic stale +3
2. [CT-2751] Support Configuration and Enabling/Disabling Semantic Models #7968
   semantic user docs +2
   
3. [CT-2740] Ensure semantic models & metrics are included in DAG viz dbt-docs#431
   enhancement +1
   
4. [CT-3042] Support meta attribute for SemanticModel nodes #8511
   Impact: CA enhancement semantic +3
   
5. [CT-3041] [Bug] Semantic Model nested element descriptions do not support doc blocks #8509
   backport 1.6.latest bug semantic +3
   
6. [CT-3073] [Bug] semantic model doesn't work in the "plus" node selection #8546
   Impact: Exp backport 1.6.latest bug semantic +4
   
7. [CT-3102] [Bug] semantic models don't support partial parsing #8609
   bug partial_parsing +2

Ergonomics

Preview Give feedback

1. [CT-2526] Create Metric node for measures with create_metric: true during parsing #7504
   semantic user docs +2
   
2. [CT-2855] [Feature] dbt_utils.date_spine should be added to core given new MetricFlow requirements #8172
   enhancement user docs utils +3
   
3. [CT-2938] [spike] Automate creation of metricflow_time_spine if the project defines semantic objects #8319
   enhancement semantic +2
   

Tech Lag

Preview Give feedback

1. [CT-2837] Stop skipping test_expression_metric #8134
   semantic tech_debt +2
   
2. [CT-2838] Enabling deferral for metrics #8135
   enhancement semantic stale +3
3. [CT-2840] Improve Metric and SemanticModel related tests that ensure core protocol implementations satisfy the DSI protocols #8136
   semantic tech_debt +2
   
4. [CT-2842] Add SemanticModel tests to test_contracts_graph_parsed #8139
   semantic tech_debt +2
   
5. [CT-2843] Add Partial Parsing tests for Semantic Models #8140
   semantic tech_debt +2
   
6. [CT-2844] Improve SemanticModel related tests that ensure core protocol implementations satisfy the DSI protocols #8141
   semantic tech_debt +2
7. [CT-2845] Add tests for the depends_on property of SemanticModels #8142
   semantic tech_debt +2
   

Documentation

Preview Give feedback

1. [CT-3044] Add documentation of meta as supported attribute of Metric nodes #8513
   +0
2. [CT-3045] Add documentation of meta as supported attribute of SemanticModel nodes #8514
   +0