Allow Custom Authentication type configuration for DB connection

[rgrohitg]

Is your feature request related to a problem? Please describe. Current databricks connection setup allows only access token, and cannot be changed to configure other type

Describe the solution you'd like to allow authType for databrciks or any other setup, where based on organisation authentication mechanism we can configure it. in this case if I want to confugure OAuth configuration for databricks , there is no way to configure it.

Describe alternatives you've considered No alternative solution, unable to use cubejs as auth mechanism is not supported by my organisation authenticatoin mechanism of Oauth.

[igorlukanin]

Hi @rgrohitg 👋

As far as I see, the official Databricks SQL Driver for Node.js that Cube uses internally supports OAuth authentication, so that might in turn be supported by Cube as well.

Please feel free to check code examples and source code of that driver.

[github-actions[bot]]

If you are interested in working on this issue, please leave a comment below and we will be happy to assign the issue to you. If this is the first time you are contributing a Pull Request to Cube.js, please check our contribution guidelines. You can also post any questions while contributing in the #contributors channel in the Cube.js Slack.

[sdotz-cb]

I am also interested in if we can leverage oauth for the db connection. We rely on the DB to manager user permissions, and can't afford to replicate complex permissions within cube itself. Need to query on behalf of the user.