Error 1706, "Feature 'FOREIGN (non-SHARD) key to a sharded table' is not supported by MemSQL

Trying to create a many to many relationship table in memsql through sqlalchemy. But got this Error 1706, "Feature 'FOREIGN (non-SHARD) key to a sharded table' is not supported by MemSQL

user_camera = Table('usercamera', Base.metadata,
                    Column('user-id', BIGINT, ForeignKey('user.id')),
                    Column('camera-id', String(length=180), ForeignKey('camera.id')))

class User(Base):
    """represents a user"""
    __tablename__ = 'user'
    id = Column(BIGINT, primary_key=True)
    email = Column(String(length=180))
    password = Column(String(length=180))
    create_time = Column(String(length=180))
    camera = relationship('Camera', secondary=user_camera, back_populates="user")
    
class Camera(Base):
    """represents a camera"""
    __tablename__ = 'camera'
    id = Column(String(length=180), primary_key=True)
    name = Column(String(length=180))
    user = relationship('User', secondary=user_camera, back_populates='camera')

How do I fix it, or better a many to many relationship the RIGHT way in memsql?