[FEATURE] validate driver and server constraints on connect

[xsgao-github]

Is your feature request related to a problem? Please describe.
One JDBC driver can be used to connect to different versions of the same database, or even different database kinds (e.g. Postgres wire protocol is used by different database venders). And different versions of JDBC might be used as well.

I my case, I want to validate the database product name and version in my Tableau connector.

Describe the solution you'd like
I would like to access and validate some attributes via JDBC DatabaseMetaData interface, e.g. getDatabaseProductName(), getDatabaseProductVersion(), getDriverName() and getDriverVersion(). If the validation fails, error it out and close connecting.

Regarding to the validation rules, I would like to be able to define a callback function somewhere so Tableau connector SDK can call it after connection is made.

Describe alternatives you've considered
No workaround exist for this problem.

About You
Name: Song Gao
Company: Starburst Data

[rosswbrown]

Tracked with: W-14701240

[leniartek]

Very useful feature.

Another use case:
Most of the database providers offer the same product as a self managed on-prem or fully managed SaaS.
Sometimes it makes sense to adapt Connector behaviour (ex. available authentication methods) based on the type of data source.