You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
From a remote client, I need to write a script that connects to my SQL Warehouse using a workspace level service principal and creates an SQLAlchemy engine.. which I can then pass to a library that expects the engine.
I did write example scripts that:
connect using the Service Principal via python dbapi, thanks to the example provided.
creates a SQLALchemy engine using a PAT
I tried quite a few things including using pyodbc, only to discover that it fails as databricks_dbapi/odbc.py only supports username/password or PAT
Is there a way to create a SQLAlchemy engine connected to a SQL Warehouse using a service principle?
The text was updated successfully, but these errors were encountered:
From a remote client, I need to write a script that connects to my SQL Warehouse using a workspace level service principal and creates an SQLAlchemy engine.. which I can then pass to a library that expects the engine.
I did write example scripts that:
I tried quite a few things including using pyodbc, only to discover that it fails as databricks_dbapi/odbc.py only supports username/password or PAT
Is there a way to create a SQLAlchemy engine connected to a SQL Warehouse using a service principle?
The text was updated successfully, but these errors were encountered: