I am trying to configure apache superset with PostgreSQL as metadata database. I provided below sqlalchemy URL:

SQLALCHEMY_DATABASE_URI = "postgresql://superset_user:password@db_host:5432/superset_db?options=-c%20search_path=my_schema%20-c%20role=superset_writer"

I want to use a specific schema plus also want to set a role. But I get error: no schema has been selected to create in

Any idea how can I do so?