target.schema should return the schema for the environment being evaluated

[crericha]

dbt users expect target.schema to point to the schema for their active environment (aka target). sqlmesh should match that behavior to support run-time adapter queries that dynamically fetch tables.

[tobymao]

@crericha is this still an issue?

[crericha]

Yes, still an issue. target.schema will point to prod. It's unclear to me what schema should be provided as the snapshot may be shared by multiple environments. We'll need to talk through this one.