[destination-databricks] connection to Azure Databricks - Error 504 with V3.1.0

[betizad]

Connector Name

destination-databricks

Connector Version

3.1.0

What step the error happened?

Configuring a new connector

Relevant information

I'm trying to make a new connecion to a sql warehouse on Azure Databricks. The wareouse is not behind any firewall or vnet and is accessible diretly.
When trying to make a new connection:

• I get HTTP error 401 while authenticating with PAT and setup fails.
• I get FAILURE_OAUTH_REQUEST while authenticating with OAuth and setup fails.

I also do not find any logs in databricks workspace queries history, as if the warehouse has not been reached.

The setup documentation seems to be incomplete for azure databricks.

• username and password are not valid in azure databricks and PAT should be sufficient
• in OAuth mode, there is also a need for TenantId field

P.S. I am able to connect with V 1.1.0 but I would like to use refresh feature and incremental deduplication features in V3.
PAT_check_connection_destination-failure-37310705-ea7a-4c1e-a507-beacd7201ea7.txt
OAuth_check_connection_destination-failure-4784245b-19bb-4a7d-8908-15afff8a36fe.txt

Relevant log output

No response

Contribute

• Yes, I want to contribute

[octavia-squidington-iii]

At Airbyte, we seek to be clear about the project priorities and roadmap. This issue has not had any activity for 180 days, suggesting that it's not as critical as others. It's possible it has already been fixed. It is being marked as stale and will be closed in 20 days if there is no activity. To keep it open, please comment to let us know why it is important to you and if it is still reproducible on recent versions of Airbyte.