Add `DimensionLookup` to break-up `SemanticModelLookup` #2545

Job	Run time
BigQuery Tests	0s
Redshift Tests	0s
Snowflake Tests	0s
Databricks Tests	0s
Trino Tests	0s
Remove Label After Running Tests	0s
	0s

Provide feedback