[FEATURE]Set additional params to server

[fokot]

Is your feature request related to a problem? We want JDBC driver to work with multitenant Opensearch and use api key distinguish between tenants.

What solution would you like? We need one custom parameter to be sent in every request to the server and we will have multitenant (access rights) proxy before Opensearch. Is it possible now? How? When I set custom parameter in jdbc url I do not see it being sent to the server.

What alternatives have you considered? Using some other parameter e.g. user. But I couldn't see it sent to the server even when I set it up in jdbc params after port or as user. Or we can use context-path it is working.

[dai-chen]

@fokot Thanks for reporting the issue! Will look into the code but I guess currently JDBC may just ignore custom parameter. I wonder what kind of parameter you want to pass to OpenSearch API? Thanks

[Yury-Fridlyand]

Note: This is relevant for ODBC driver as well.

[dai-chen]

Previous request from community: https://github.com/opendistro-for-elasticsearch/sql/issues/693

Probably we should think about add support for this.

[fokot]

We want to pass apiKey for authorisation so the request will go via our proxy server. We have multi tenant OpenSearch.

[dai-chen]

We want to pass apiKey for authorisation so the request will go via our proxy server. We have multi tenant OpenSearch.

Thanks for the info! Will evaluate if we can support this.