Connection to Azure Blob

To connect Azure Blob Storage to the DQC Platform, you can authenticate using an account key, SAS token, or service principal. This guide explains each method and outlines recommended security practices.


Add an Azure Blob connector

To begin:

  1. Navigate to the Data Connectors screen

  2. Click the Azure Blob button

  3. Select your preferred authentication method

  4. Enter the required values (see below)

Choose Azure Blob as your file-based data source.


Required Connection Information

Option 1: Account key authentication

Field

Example

Description

Name

DataLakeObjectStore

Internal name for the connection

Account name

username

Storage account username

Account key

secret_account_key

Storage key from Azure

Container path

abfs://my-container

Full URI to the blob container


Option 2: SAS token authentication

Field

Example

Description

SAS token

sp=rl&st=...&sig=...

Time-limited signed token string

Container path

abfs://my-container

URI to the specific blob container


Option 3: Service principal authentication

Field

Example

Description

Tenant ID

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

Azure AD directory identifier

Client ID

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

App registration / principal identifier

Client secret

*************

Password (secret) for the app

Container path

abfs://my-container

Full URI to blob container


Recommended access configuration

To ensure secure integration, follow these best practices:

Use a dedicated minimal-privilege account

  • Create a dedicated service principal, storage user, or token

  • Avoid using owner or admin accounts

Grant read-only access

  • Limit the connected account to read-only permissions

  • Prevent unintended write, delete, or overwrite actions

Restrict scope

  • Configure access only for the required container

  • Use container-specific SAS tokens or scoped role assignments

Whitelist the DQC platform IP address

Allow inbound traffic from the DQC Platform's static IP:

3.123.94.228


Troubleshooting

When DQC cannot connect to Azure Blob or load its tables, it shows the reason with a short fix and links to this section. Look up the beginning of the message:

Message in DQC

Likely cause

Fix

Cannot specify more than one authentication method

Account key and SAS token are both filled in

Keep one authentication method

Must specify at least one authentication method …

No method is complete

Fill in one option completely (see Required Connection Information)

Could not connect to the data source. …

Wrong container path, an expired SAS token or one without List and Read, missing Storage Blob Data Reader role, or the storage firewall blocks the DQC IP address

Enter the container path as container/folder (no URL), renew the SAS token, assign the role, and allow the DQC Platform IP address in the storage firewall

Table not accessible anymore …

The file was deleted or renamed after the last sync

Restore or rename the file, then resync the connector

  • Synchronization failed: when a sync cannot connect, the connector shows Failed on the Data sources screen and the badge links to this section. Edit the connector and click Load tables or Save: DQC tests the connection again and shows the current reason.

  • Files missing from the table list: DQC lists CSV, JSON and Parquet files directly in the container path. Excel files are not supported on Azure Blob; convert them to CSV or Parquet.

  • One broken file blocks the connector: fix the file or move it out of the container path.

  • Still stuck? Write to support@dqc.ai with the connector name, the time of the attempt and the full message.


💡 Notes