Connecting Django to Microsoft Fabric Warehouse

Based on the error message and your configuration, there appears to be an issue with how Django is parsing your connection string attributes for Microsoft SQL Server with Azure AD authentication.

Issue Analysis

The error Invalid connection string attribute (0) typically indicates a problem with the format or parameters in your connection string. While your standalone Python script works, Django's database configuration has different requirements.

Suggested Solution

For connecting to Microsoft SQL Server with Azure AD Service Principal authentication in Django, try the following approach:

PYTHONCopied
'FabricDW': {
    'ENGINE': 'django.db.backends.mssql',  # Use the full path to the engine
    'NAME': CONFIG["WAREHOUSE_DB_NAME"],
    'HOST': CONFIG["WAREHOUSE_HOST"],
    'PORT': '1433',
    'OPTIONS': {
        'driver': 'ODBC Driver 17 for SQL Server',
        'authentication': 'ActiveDirectoryServicePrincipal',
        'uid': f'{CONFIG["AZURE_CLIENT_ID"]}@{CONFIG["AZURE_TENANT_ID"]}',
        'pwd': CONFIG["AZURE_CLIENT_SECRET"],
    },
}

Key changes:

1. Changed 'ENGINE': 'mssql' to 'ENGINE': 'django.db.backends.mssql'
2. Moved authentication details to the OPTIONS dictionary with proper parameters
3. Formatted the UID to include the tenant ID

Alternative Approach

If the above doesn't work, you could try using a DSN-less connection string directly:

PYTHONCopied
'FabricDW': {
    'ENGINE': 'django.db.backends.mssql',
    'NAME': CONFIG["WAREHOUSE_DB_NAME"],
    'HOST': CONFIG["WAREHOUSE_HOST"],
    'OPTIONS': {
        'driver': 'ODBC Driver 17 for SQL Server',
        'connection_string': (
            f'Driver={{ODBC Driver 17 for SQL Server}};'
            f'Server={CONFIG["WAREHOUSE_HOST"]};'
            f'Database={CONFIG["WAREHOUSE_DB_NAME"]};'
            f'UID={CONFIG["AZURE_CLIENT_ID"]}@{CONFIG["AZURE_TENANT_ID"]};'
            f'PWD={CONFIG["AZURE_CLIENT_SECRET"]};'
            'Authentication=ActiveDirectoryServicePrincipal;'
        ),
    },
}

Additional Considerations

1. Make sure you have the correct database backend installed:

   pip install django-mssql-backend
   

2. Verify that your ODBC driver is properly installed and accessible

3. Double-check that all your configuration values are correct, especially the tenant ID which is missing in your original configuration but present in your working script

The key difference between your working script and Django configuration is how the connection parameters are structured and passed to the database driver. Django's database layer has specific expectations for how these parameters should be formatted.