Connect Pigment with Azure Blob Storage

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

From your Azure Portal homepage, first head to App registrations:

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

Azure Step 2 - Get authentication credentials

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

Application (client) ID
Directory (tenant) ID

Go to Certificates & secrets.

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

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

Go to Azure Portal homepage, then select Storage accounts.
Select an existing Storage account or create a new one, and save its name.
In the Storage account, select an existing Container or create and name a new one.
Note the storage account name and container name. You will need them to complete the setup in Pigment.

Azure Step 4 - Set IAM permissions on the Container

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

Create a connection in Pigment

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

Name: Connection name.
Application ID: Azure application ID. This is described in Step 2.
Directory ID: Azure directory ID This is described in Step 2.
Secret value: Client secret value that you generated in Step 2.
Account name: Name of your Azure storage account. This is described in Step 3.
Container name: Name of your Azure storage container. This is described in Step 3.

ℹ️ 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:

Open Pigment and go to an Application where this connection is available.
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.
Select the Integration tab in the Import data pane.
In the Choose a connection menu, select your Blob Storage connection.
Select which Import mode you want, both options are described in more detail below.

Fixed file

This import mode chooses one individual file name.

Enter the file path, including the folder name and file name with extension. For example:
folder1/folder2/file.csv
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. 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.

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.

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.