topic Re: Creating Linked Service in ADF to link Databricks Community Edition in Data Engineering

Creating Linked Service in ADF to link Databricks Community Edition

manideep04d — Tue, 24 Sep 2024 18:13:17 GMT

Using Current Community Edition I was Unable to create a linked service
unable to generate/copy personal Access Token .

Tried Installing ODBC but unable to set it properly.

Any suggestions / Help would be highly Appreciated

Re: Creating Linked Service in ADF to link Databricks Community Edition

roxanne41watts — Sat, 11 Jan 2025 06:02:41 GMT

You're having difficulty creating a linked service and generating a personal access token with the current Community Edition. Ensure your account has the necessary permissions, and follow the correct steps to generate a personal access token from your account settings. For the ODBC configuration, verify that you have the correct driver installed and configured properly. Also, ensure all your software is up to date and refer to the official documentation for detailed guidance.

Re: Creating Linked Service in ADF to link Databricks Community Edition

Walter_C — Sat, 11 Jan 2025 14:10:34 GMT

In community Edition workspaces the PAT token is not allowed, instead of this you might need to generate an Oauth token to be able to authenticate: https://docs.databricks.com/en/dev-tools/auth/oauth-u2m.html

You can refer to the ODBC guide in page 19 to make use of this token https://docs.databricks.com/en/_extras/documents/Simba-Apache-Spark-ODBC-Connector-Install-and-Configuration-Guide.pdf