Set search path

How can I set the search path for a session?

Ideally, I would like to be able to change the search path after the session is initiated.

I tried using the following command, but subsequent queries don't seem to use the schema:

%%nql

SET search_path = {{schema_name}}, public

You would need todo as it will try and treat schama name as a paremeter. So you need so say it is raw sql like:

%%nql

SET search_path = {{schema_name | sql}}, public

Also you can do session.schema = 'schema_name, public' to the session to change the schema for all following queries.

Also you can do session.schema = 'schema_name, public' to the session to change the schema for all following queries.

Great, that would be good to add to the readme.

Navigation Menu