Ecto change @schema_prefix on a join statement

[CastLouis]

i was using another post to resolve it:

Ecto Cross-schema join

FWIW, you should be able to do: join: c in fragment("some_other_schema.example") or at least: join: c in fragment("SELECT * FROM some_other_schema.example") which you can easily encapsulate in a macro. But you do lose the Ecto schema information (although Ecto has many tools to help with that).