Skip to content
Create account
or
Sign in
The Stripe Docs logo
/
Ask AI
Create account
Sign in
Get started
Payments
Finance automation
Platforms and marketplaces
Money management
Developer tools
Get started
Payments
Finance automation
Get started
Payments
Finance automation
Platforms and marketplaces
Money management
Overview
Billing
Tax
Reporting
Data
    Overview
    Schema
    Custom reports
    Sigma API
    Create custom reports
    Write queries using Sigma
    Query data across an organization
    Sync Stripe data
    Access data within a data warehouse
    Export data to a data warehouse
    Export data to cloud storage
      Export data to Google cloud storage
      Export data to AWS S3 storage
      Export data Azure Blob storage
      Diagnose connection issues with cloud storage
      Cloud storage file organization
    Data management
    Data freshness
    Business and product data use cases
    Import external data
Startup incorporation
HomeFinance automationDataExport data to cloud storage

Export data to Azure Blob Storage

Automate recurring data exports from Stripe to your Azure Blob Storage container.

Copy page

Azure Blob Storage destination

The Azure Blob Storage destination delivers copies of all your Stripe data as Parquet files into your Azure Blob Storage account. It contains a directory of files for each table, delivered and updated every 6 hours.

Prerequisites

Before starting the integration, make sure you have access to:

  1. Create a new Azure App Registration.
  2. Create a new Azure Storage account.
  3. Create a new Azure Storage container.
  4. Access the Stripe Dashboard as an admin.

Create a new Azure App Registration

  1. On the App registrations page, click + New Registration.
  2. Enter a name for this application and click Register.

    Note

    Don’t make any changes to either the Supported account types field or the Redirect URI field.

  3. Make a note of the Application (client) ID and Directory (tenant) ID values from the Overview page of created app registration.
  4. Click Add a certificate or secret link in the same section or click Manage > Certificates & secrets.
  5. Click + New Client Secret and enter a description and set Expires to 730 days (24 months).
  6. Click the Copy to clipboard icon to copy the Value field (client secret value) and make a note of it.

Create a new Azure Storage account

  1. On the Storage accounts page, click + Create.
  2. Choose a Subscription and Resource group.
  3. Enter a Storage account name that’s unique across all Storage accounts in Azure (for example, “stripeuniquename” or “stripeasd5dwju8awkwe”).
  4. Choose a Region.

    Caution

    We don’t support data regions in India. Let us know if you have questions about support for your desired region.

  5. Choose a Performance level and Redundancy option.
  6. Click Review + create.
  7. Review your settings and click Create.
  8. After creating the account, click Go to resource. Resource creation typically completes within 15 seconds.
  9. Make a note of Resource group value and Subscription ID values as shown in the Overview section.

Create a new Azure Storage container

  1. Click Data storage > Containers in the left pane.
  2. Click + Container.
  3. Choose a name for your container (for example, “stripe-data”).
  4. Set anonymous access level to Private (no anonymous access).
  5. Click Create.
  6. Click the created container and go to Settings > Properties in the left pane.
  7. Make a note of the container URL field.

Grant permissions on Storage account

  1. Navigate to your created Storage account page.
  2. Click Access Control (IAM) in the left menu.
  3. Click Add then Add role assignment
  4. Search for the Storage Blob Data Contributor role and select it, then click next.
  5. Click + Select members and search with the application name created in step 2.2
  6. Select the corresponding application shown in the dropdown and click select.
  7. Click Review + assign.
  8. Verify if the role and application name display correctly, and Click Review + assign. The role assignment completes after it processes.
  9. Follow the same steps from 1-7 and search for and select the Reader and Data Access role in step 4 instead.
  10. By following these instructions, you grant both the Storage Blob Data Contributor and Reader and Data Access roles to your registered application for the storage account.

OptionalGenerate encryption keys

Establishing Your Azure Blob Storage Connection

  1. Visit the Data Pipeline Dashboard.
  2. Click Get started.
  3. Select the Microsoft Azure warehouse.
  4. Enter the Client ID, tenant ID and Client secret generated in step 2.
  5. Enter the Subscription ID and Resource group values generated in step 3.
  6. Enter the Container URL generated in step 4.
  7. Select your data encryption option. If you chose to use a customer managed key, upload your public key.
  8. Click Next. Clicking Next sends test data to the container on the storage account you provided, but not production data.
  9. When you confirm test data delivery, go to your container on the Azure Storage account.
  10. Open the container, navigate to the penny_test directory, and open the acct_ or org_ prefixed sub-directory to locate the delivered account_validation.csv test file.
  11. Click the account_validation.csv file
  12. Click DOWNLOAD.
  13. Click Upload file in the Stripe Dashboard and upload the downloaded account_validation.csv file.
  14. When the file shows as verified, click Subscribe. This subscribes you to the product and schedules the initial full load of data for delivery to your container on the Azure Storage account, a process that can take 6-12 hours.
Was this page helpful?
YesNo
Need help? Contact Support.
Join our early access program.
Check out our changelog.
Questions? Contact Sales.
LLM? Read llms.txt.
Powered by Markdoc