Using Entra ID for authenticating in drizzle.config.ts

import { defineConfig, type Config } from 'drizzle-kit';
if (!process.env.DATABASE_URL) throw new Error('DATABASE_URL is not set');

import { ClientSecretCredential, DefaultAzureCredential } from '@azure/identity';

const host = "elephant-dev.postgres.database.azure.com:5432/sagalabs";
const database = "sagalabs";
const port = 5432;
const ssl = true;

const credential = new DefaultAzureCredential();
var accessToken = await credential.getToken('https://ossrdbms-aad.database.windows.net/.default');


export default defineConfig({
  schema: './src/lib/schema.ts',
  dbCredentials: {
    host: host,
    database: database,
    port: port,
    user: `SagaLabs-Dev-staging`,
    password: accessToken.token,
    ssl: ssl ? { rejectUnauthorized: false } : false,
  },
  verbose: true,
  strict: true,
  dialect: 'postgresql'
}) satisfies Config;