Hello All.... I'm trying to setup the destination ...
# replication-troubleshooting
s
Hello All.... I'm trying to setup the destination as Databricks Lakehouse on Azure but connection is failing though all the details provided are valid. Here is the error message- ------------------------------------------------------- Could not connect to the staging persistence with the provided configuration. Status code 401, "<?xml version="1.0" encoding="utf-8"?><Error><Code>NoAuthenticationInformation</Code><Message>Server failed to authenticate the request. Please refer to the information in the www-authenticate header. RequestId:42b90c05-901e-0008-6d4a-2de6c7000000 Time2023 01 21T0346:35.3952225Z</Message></Error>" ------------------------------------------------------- Also, I think Data Source should be optional in the implementations where the storage would be handled automatically. Any help or documentation would be greatly appreciated.
u
Hello Somasekhar, can you confirm the Airbyte server has network access to your Databricks server and you have generated the HTTP Path and Personal token correcty?
s
I tried using the same connection strings (host, http endpoint, http path, and PAT) to connect to databricks from my local machine using DBeaver and it worked. Looks like issue is to do with Azure blob container details. However, I have cross checked all the storage account details and are correct. PS: I have installed Airbyte in my local machine using Docker Desktop and created source and destinations using APIs. Using ADLS Gen2 as a datasource,
Got this Issue resolved. It was a network connectivity issue to Blob storage.
u
Nice to hear Somasekhar!