How to set search_path while setting up pgsql connection

1

Hello,

We are using Metabase Cloud.

I have added the following search_path option

-c search_path=public,salesforce

to

Additional JDBC connection string options input field on metabase admin.

I am only able to query the objects in salesforce schema on via prefixing the table name with salesforce..

By adding search_path, we do not need to specify the schema name. But that is not working.

Any idea what is going on here?

Is JDBC Connection string options input field the right place to set that search_path?

Thanks.

2

If you use our cloud please contact us through the support channel as you have premium support with SLAs