Hi,
We are using Databricks bundles to deploy our DBT project. Everything is set up to deploy and run as a Service Principal.
The DBT job is connected to an Azure DevOps repository. The problem is that we cannot find a way to properly authenticate the SP and the repository. The only way we found is to use the Databricks cli / api to create a git connection, however you can only add a PAT. As far as I know you are not able to generate a PAT for a service principal in Azure DevOps. If the PAT needs to be generated by a user anyway, this defeats the whole purpose of using a SP.
What is the best way to set this all up without using user accounts?
Thanks!