Authentication Issue while connecting to Databricks using Looker Studio

ashraf1395
Honored Contributor

So previously I created source connections from looker with Databricks using my personal access token.

I followed this databricks docs. 
https://docs.databricks.com/en/partners/bi/looker-studio.html

But from 10 July, I think basic authentication has been removed from databricks.
I am getting this error now

ashraf1395_0-1723631031231.png

I checked the docs and found out that we can correct this by using service principals instead of personal access token.

So I have created service prinipal, and given these permissions

ashraf1395_1-1723631308249.png

and generated secret key.

Now how should i authenticate it in looker.

What should i pass in Username field - "token", or service principal name or client id or anything else I tried all these got error.

ashraf1395_2-1723631479463.png

@Retired_mod