search

opensearch-project / sql-odbc

OpenSearchODBC is a read-only ODBC driver for Windows and Mac for connecting to OpenSearch SQL support.
Apache License 2.0
7 stars 17 forks source link

[FEATURE] SQL Serverless support #70

Open Swiddis opened 3 weeks ago

Swiddis commented 3 weeks ago

Is your feature request related to a problem? When using the ODBC driver to connect to a Serverless SQL instance, the driver fails to connect. This is because Serverless has a restricted API set, including removing several of the status APIs that the driver uses to test for API health. We already have example implementations for both SQL CLI and SQL JDBC that skip these checks in a serverless environment.

What solution would you like? When a serverless link is provided instead of a standard cluster link, the driver should skip calling status endpoints on serverless so it can connect correctly.

What alternatives have you considered? N/A

Do you have any additional context? N/A

jduo commented 2 weeks ago

@Swiddis , related to the solutions for SQLCLI and JDBC, these appear to detect SQL Serverless by parsing the URL. I think we should add a specific config option to use Serverless as well (maybe auto-detect by default). Relying on using URL-parsing exclusively might miss some cases (for example using a proxy, or perhaps the user created an alias for the AWS host).

currantw commented 6 days ago

Created an pull request for this issue. It determines whether it is serverless by parsing the URL for aoss.amazon.com. Automated testing for this feature has been deferred to https://github.com/opensearch-project/sql-odbc/pull/75.