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.