Databricks online store - Login to Azure SQL Database with Service Principal

romanzdk — Thu, 28 Apr 2022 11:32:17 GMT

I want to use Databricks Online Store with Azure SQL Database, however I am unable to autenthicate through Databricks Feature Store API. I need to use Service Principal credentials.

I tried using Application ID as username and Secret as password, but no luck - `com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user '[REDACTED]'. ClientConnectionId:some-id-x-x-`.

I also tried to generate AAD access Token and use it as a password, however I am getting

`password exceeds maximum length of 128characters`..

When I use the same credentials to test it via JayDeBeApi everything works...

Code I am using:

from databricks.feature_store.online_store_spec import AzureSqlServerSpec
from databricks.feature_store import FeatureStoreClient
 
username = "application-id"
password = "application-secret"
tenantId = "tenant-id"
server_name = "server-name.database.windows.net"
port = "1433"
db_name = "database-name"
 
fs = FeatureStoreClient()
 
online_store = AzureSqlServerSpec(
    hostname=server_name,
    port=1433,
    database_name=db_name,
    user=username,
    password=password,
    table_name="TableName",
)
 
fs.publish_table(
  name='feature_store.TableName',
  online_store=online_store,
  mode='merge'
)

Re: Databricks online store - Login to Azure SQL Database with Service Principal

romanzdk — Mon, 02 May 2022 08:13:45 GMT

no one?

topic Databricks online store - Login to Azure SQL Database with Service Principal in Machine Learning

Databricks online store - Login to Azure SQL Database with Service Principal

Re: Databricks online store - Login to Azure SQL Database with Service Principal