Due to legacy metadata choices, the create table happens only in the context of the current schema. So its name, even if multi-part, is local to that schema. Unfortunately that is not aligned with the spec.
Can a fully qualified name of <Table> is used when creating a Foreign Table and if so will this result in a model for the Schema predicate ?