pop up when using databrics sql

kay0291 — Tue, 28 Oct 2025 14:07:15 GMT

Hello,

I am uning databricks sql to read from a unity catalog table locally on a python project using an azure sp client id and client secret
the connexion is successful however i have a pop up that asks me to connect to my azure env
is there a way to make this connexion without the pop up since we go through a client secret and a client id ?

this is my code

from databricks import sql

from dotenv import load_dotenv

load_dotenv()

def get_conn():

return sql.connect(

server_hostname=os.getenv("DATABRICKS_HOST"),

http_path=os.getenv("DATABRICKS_HTTP_PATH"),

auth_type="azure-client-secret",

azure_client_id=os.getenv("client_id"),

azure_client_secret=os.getenv("client_secret"),

azure_tenant_id=os.getenv("tenant_id"),

)

with get_conn() as conn, conn.cursor() as cur:

cur.execute("SELECT * FROM *")

for row in cur.fetchall():

print(row)

thank you !

Re: pop up when using databrics sql

AbhaySingh — Wed, 29 Oct 2025 12:34:07 GMT

In your .env file, add:

DATABRICKS_WORKSPACE_RESOURCE_ID=/subscriptions/your-sub-id/resourceGroups/your-rg/providers/Microsoft.Databricks/workspaces/your

-workspace

Alternative approaches if the popup persists:

1. Use OAuth machine-to-machine (M2M) authentication (recommended for newer workspaces):

auth_type="databricks-oauth"

2. Ensure your service principal has proper permissions:

- The SP needs to be added as a user in your Databricks workspace

- Grant it appropriate permissions on Unity Catalog

3. Try setting environment variable to disable browser-based auth:

os.environ["DATABRICKS_AUTH_TYPE"] = "azure-client-secret"

Let me know if the popup still appears after these changes!

topic Re: pop up when using databrics sql in Generative AI

pop up when using databrics sql

Re: pop up when using databrics sql