The following code works fine if table t is on the connecting user's search_path. I would like to be able to specify, in code, which schema to search. The only way I can make the code work is by issuing a alter user on the backend.
alter user username set search_path=schema_name;
import ibis
con = ibis.postgres.connect(url = "postgresql+psycopg2:///?service=service_name")
t = con.table("t")
y = t.group_by("b").mutate(z=t.a.sum())
How can i specify seach_path on the Postgres backend to ibis?
Regards
