---

title: Azure Blob Storage sidebarTitle: Azure Blob Storage

This documentation describes the integration of MindsDB with [Azure Blob Storage]

Prerequisites

Before proceeding, ensure that MindsDB is installed locally via Docker or Docker Desktop.

Connection

Establish a connection to your Azure Blob Storage from MindsDB by executing the following SQL command:

CREATE DATABASE azureblob_datasource
WITH
    engine = 'azureblob',
    parameters = {
      "container_name":"",
      "connection_string":""
    };

Required connection parameters include the following:

• container_name: The name of your container.
• connection_string: The connection string of your account, we prefer connection string from Shared Access Signature as it has expiry date, time, and permission control as well, you can found it under "Security & Networking" menu >> "Shared Access Signature".

Inside Shared Access Signature menu:

• Tick all checkboxes for Allowed services, Allowed resource types, Blob versioning permissions, Allowed blob index permissions. (Adjustable based on your needs) For Allowed permissions, tick all except Permanent delete & Immutable storage.
• Then Finally click "Generate SAS & connection string".
• Use the generated connection string to connect.

Usage

Retrieve data from a specified object (file) in the Azure Blob Storage by providing the integration name and the object key:

SELECT *
FROM azureblob_datasource.`my-file.csv`;
LIMIT 10;

Wrap the object key in backticks (\`) to avoid any issues parsing the SQL statements provided. This is especially important when the object key contains spaces, special characters or prefixes, such as `my-folder/my-file.csv`.

At the moment, the supported file formats are CSV, TSV, JSON, and Parquet.

The above examples utilize `azureblob_datasource` as the datasource name, which is defined in the `CREATE DATABASE` command.

Known Issue

`Problem with the SSL CA cert` (you most likely get this error if your current OS is ubuntu / other linux distro)

• Symptoms: Error: Invalid Error: Fail to get a new connection for: https://⟨storage account name⟩.blob.core.windows.net/. Problem with the SSL CA cert (path? access rights?))

• Solution: Current workaround is executing the following 2 statements as root: mkdir -p /etc/pki/tls/certs ln -s /etc/ssl/certs/ca-certificates.crt /etc/pki/tls/certs/ca-bundle.crt

References: https://duckdb.org/docs/extensions/azure.html#authentication https://medium.com/datamindedbe/quacking-queries-in-the-azure-cloud-with-duckdb-14be50f6e141