sqlalchemy - select table from other schema

Question

I have a table from schema "test":

class AttributeConversion(Base):
    __tablename__ = 'test.attribute_conversion'

How to select records from this table?

SQLAlchemy generates SQL:

select * from "test.attribute_conversion"

But it doesn't work. The correct query must be:

select * from test.attribute_conversion  (without quotes)

Answer 1

You can explicity specify a schema name for a table:

class AttributeConversion(Base)
    __tablename__ = 'attribute_conversion'
    __table_args__ = {'schema' : 'test'}

See documentation on specifying the schema name.