Issue with connecting to Fabric Warehouses from Node Driver

[joe-statsig]

Hi team, I'm currently able to perform the OBO flow in my node server to perform REST Apis calls against the Fabric APIs to grab warehouse information.

I'm trying to connect to SQL warehouses via the documentation here: https://learn.microsoft.com/en-us/fabric/workload-development-kit/fabric-data-plane#reading-data

I believe I've followed the steps to correctly grab an OBO token with https://database.windows.net//user_impersonation scope as instructed but am having trouble actually completing the connection flow with the Tedious driver in Node.

Would anyone be able to pick out what might be wrong with my implementation here?

` const msalConfig = {
auth: {
clientId: 'clientId',
authority: 'https://login.microsoftonline.com/tenantId',
clientSecret: 'secret',
},
};

  const msalClient = new ConfidentialClientApplication(msalConfig);

  const oboRequest = {
    oboAssertion: accessToken, // accessToken from Fabric Iframe client
    scopes: ['https://database.windows.net//user_impersonation'],
  };

  const response = await msalClient.acquireTokenOnBehalfOf(oboRequest);

  const databaseConfig = {
    server: 'uuid.datawarehouse.fabric.microsoft.com',
    authentication: {
      type: 'azure-active-directory-access-token',
      options: {
        token: response.accessToken,
      },
    },
    options: {
      encrypt: true,
      database: 'databasename',
      port: 1433,
      rowCollectionOnRequestCompletion: true,
    },
  };

    const connection = new Connection(databaseConfig);
    connection.connect();

It looks to me like grabbing the OBO token is working fine but Tedious seems to reject the credentials at the SentTLSSSLNegotiation -> SentLogin7WithStandardLogin step of connection.

[ghost]

tediousjs/tedious#1668

tedious has open issues in connecting to warehouses.