Azure Billing Exports Connection

Let's create a billing export in Azure Blob Storage and grant Cloudchipr’s service principal access.

1. Create New Export

Go to the Cost Exports page, click on the Create button, and choose Cost and usage (actual + amortized)

2. Add Datasets

Add Exports Prefix, for example: c8r-

3. Define the Destination

As the format type of exports, choose Parquet with Snappy compression. Select boxes for File Partitioning and Overwrite, and click on Review and Create button.

4. Provide Access to the Storage Account to Cloudchipr Service Principal

Open the Storage Accounts page

In the Azure portal, go to the Storage Accounts page.

Choose your storage account

Select the storage account you specified when you created the export.

Open Access Control (IAM)

In the storage account menu, go to the Access Control (IAM) page.

Add a role assignment

Click Add role assignment.

Choose the Blob Storage Data Reader role

Search for and select the Blob Storage Data Reader role.

Assign the role to Cloudchipr

Select <service principal id> as the member, then review and assign the role.

Replace <service principal id> with Cloudchipr's service principal provided by your account executive.

5. Backfill the last 12 months

A new export only includes cost data from the day you create it. To see your cost history in Cloudchipr from day one, backfill the last 12 months.

The "Cost and usage (actual + amortized)" template creates two exports, one for actual cost and one for amortized cost. You need to backfill both.

Open Exports

In the Azure portal, go to Cost Management › Exports.

Select your actual cost export

Select your actual cost export, for example c8r-actual.

Click Export selected dates

Click Export selected dates.

Choose a month and run the export

Choose one month and run the export.

Repeat for each of the last 12 months

Repeat steps 3 and 4 for each of the 12 full months before the current month. Azure exports one month per run.

Repeat for your amortized cost export

Repeat steps 2 to 5 for your amortized cost export, for example c8r-amortized.

That makes 24 runs in total, 12 per export. You don’t need to export the current month. The daily schedule already covers it

Please send us the billing export name, container name, storage account name, and directory name chosen during export creation.