---
title: "Connect Pigment with Azure Blob Storage"
slug: "connect-azure-blob-storage"
description: "Learn to connect Azure Blob Storage to your Pigment Organization and import CSV files seamlessly into your Pigment Blocks with this step-by-step guide."
tags: ["applications", "Azure Blob Storage", "blocks", "CSV Import", "Importing Exporting Data", "Pigment Integration", "Security Permissions"]
updated: 2026-02-13T13:45:42Z
published: 2026-02-13T13:45:42Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Connect Pigment with Azure Blob Storage

![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/image(29).png)

This article explains how to connect a Azure Blob Storage with your Pigment Organization, specifically how to load a CSV file stored in a Container into a Pigment Block.

## Overview

This process starts in Azure, with the configuration of an App Registration and a Container, which you’ll use when setting up the connection in Pigment.

## Set up access

### Azure Step 1 - Create or use an existing App registration

1. From your [Azure Portal homepage](https://portal.azure.com), first head to App registrations:

![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/727ab397-e131-4aff-ba41-cf1112eb5fb7.png)

1. Select an existing registration from the application list or select **+ New registration**to create a new list.

### Azure Step 2 - Get authentication credentials

1. In **App registrations**, copy the following IDs. You will need them later to configure Pigment.

- **Application (client) ID**
- **Directory (tenant) ID**

1. Go to **Certificates & secrets**.

![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/af6d0162-5dd2-4ae6-bfe5-8aa8d80c117f.png)

1. Create a new **client secret** and copy the value. You will need this later to configure Pigment.

![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/a8dbbdaa-3cb2-4880-815c-3dc7b77b00fd.png)

### Azure Step 3 - Create or use an existing Storage account and Container

1. Go to [Azure Portal homepage](https://portal.azure.com), then select **Storage accounts**.
2. Select an existing **Storage account** or create a new one, and save its name.
3. In the **Storage account**, select an existing **Container** or create and name a new one.
4. Note the storage account name and container name. You will need them to complete the setup in Pigment.

![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/e857242f-210f-4edc-936d-5d95f20bf0f8.png)

### Azure Step 4 - Set IAM permissions on the Container

1. In the container, select the Container name and then **Access Control (IAM)**.
2. Select **+ Add,**choose **+ Add role assignment,**and assign the **Storage Blob Data Reader** role to the appropriate user or group.

![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/636ba769-f6f5-4643-bd97-de4882932acf.gif)

## Create a connection in Pigment

1. In Workspace Settings, open the **Integration** page.
2. Go to **Azure Blob Storage**and select **+Add.**
3. Complete the following fields with your saved information:

- **Name**: Connection name.
- **Application ID**: Azure application ID. This is described in [Step 2](/v1/docs/connect-pigment-with-azure-blob-storage#azure-step-2-retrieve-authentication-credentials).
- **Directory ID:** Azure directory ID This is described in [Step 2](/v1/docs/connect-pigment-with-azure-blob-storage#azure-step-2-retrieve-authentication-credentials).
- **Secret value**: Client secret value that you generated in [Step 2](/v1/docs/connect-pigment-with-azure-blob-storage#azure-step-2-retrieve-authentication-credentials).
- **Account name**: Name of your Azure storage account. This is described in [Step 3](/v1/docs/connect-pigment-with-azure-blob-storage#azure-step-3-create-or-use-an-existing-storage-account-and-container).
- **Container name**: Name of your Azure storage container. This is described in [Step 3](/v1/docs/connect-pigment-with-azure-blob-storage#azure-step-3-create-or-use-an-existing-storage-account-and-container).

> ℹ️ **Note**
> 
> To connect to multiple **containers**, you need to create multiple **connections** in Pigment.

## Use the connection in Pigment

When the connection is configured, do the following:

1. Open Pigment and go to an Application where this connection is available.
2. Select **Import data** located in the top right of the Block header.

You can also select **Start from an import**, this option is available when you create a new Block.
3. Select the **Integration** tab in the Import data pane.
4. In the **Choose a connection**menu, select your Blob Storage connection.
5. Select which **Import mode**you want, both options are described in more detail below.

### Fixed file

This import mode chooses one individual file name.

1. Enter the file path, including the folder name and file name with extension. For example: `folder1/folder2/file.csv`
2. Select **Set up import**.

The file preview loads in Pigment, the load time depends on the file size.

If you save this import configuration and reuse it or schedule it, it will always download and import this exact file.

### Most recent file

This import mode allows you to define a file path. Pigment downloads the most recent file that matches a naming convention containing an [ISO 8601–formatted date](https://en.wikipedia.org/wiki/ISO_8601). See the table below for details.

#### Naming convention in Azure Blob Storage

CSV files must follow a consistent naming convention that includes an [ISO 8601–formatted date](https://en.wikipedia.org/wiki/ISO_8601).

The table below shows an example CSV file, `rev.csv`, with corresponding ISO 8601–formatted dates.

| ISO-8601 Compatible Date Formats | File Name Examples: {{date}}-rev.csv |
| --- | --- |
| `yyyy-MM-dd` | 2022-09-30-rev.csv |
| `yyyy-MM-ddThh:mm:ss` | 2022-09-30T00:00:00-rev.csv |
| `yyyy-MM-ddThh:mm:ssZ` | 2022-09-30T00:00:00Z-rev.csv |

#### Pigment file path format

Define the folder path first (for example, `folder1/folder2/`), then insert `{{date}}` in the file name or path. The path is case-sensitive.

Plaintext

```plaintext
folder1/folder2/prefix{{date}}suffix.csv

folder1/prefix{{date}}suffix/file.csv
```

#### Path and result examples

**Example 1**

**Path:** `folderA/{{date}}-salaries.csv`

**Imports:** `/folderA/2025-10-15-salaries.csv`

Selects the most recent matching file in `folderA`.

**Example 2**

**Path:** `folderB/{{date}}-salaries.csv`

**Imports:******`/folderB/2025-11-15-salaries.csv`

Selects the most recent matching file in `folderB`.

**Example 3**

**Path:******/{{date}}-salaries.csv

**Imports:** No file

Folder location is missing.