Authentication Issue while connecting to Databricks using Looker Studio

ashraf1395 — Wed, 14 Aug 2024 10:35:01 GMT

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

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

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.

@Retired_mod

Re: Authentication Issue while connecting to Databricks using Looker Studio

menotron — Thu, 15 Aug 2024 07:28:14 GMT

Hi,

You would still connect using OAuth tokens. It is just that Databricks recommends using personal access tokens belonging to service principals instead of workspace users. To create tokens for service principals, see Manage tokens for a service principal. But your personal access token should work just fine as long as it hasn't expired and you have access to SQL Warehouse.

To make sure you are setting up a fresh connection ensure you revoke all existing access by doing the following.
1. Go to Manage your Google Account > Security > Your connections to third-party apps & services > Databricks Connector for Data Studio. And revoke all access and delete the connection if needed.

2. Revoke access in Looker

Now setup a new connection by authorizing the connector

Then when you are prompted to enter the Databricks credentials enter 'token' as the Username and the personal access token in the Password field.

topic Authentication Issue while connecting to Databricks using Looker Studio in Data Engineering

Authentication Issue while connecting to Databricks using Looker Studio

Re: Authentication Issue while connecting to Databricks using Looker Studio