logo
Forums Blogs Roadmap & Ideas User Groups & Events Stack Overflow Reddit
Knowledge Base My Support Cases About Support
Academy Maia Matillion ETL Certifications
Professional Services & Training Consulting Partners
Search
    • Home
    • Matillion ETL product overview
      • Explore Maia Foundation
      • Matillion ETL instance creation
      • Associating a Matillion ETL instance
      • Configuring a connection from Matillion ETL to Maia Foundation
      • Launching Matillion ETL
      • Launching Matillion ETL for GCP
        • Matillion ETL usage
          • Matillion ETL editions
          • Matillion ETL marketplace subscriptions
      • Matillion ETL observability
      • Instance sizes
        • Accessing the Matillion ETL Client (Amazon EC2)
        • Accessing the Matillion ETL Client (Google Cloud Platform)
        • Accessing the Matillion ETL Client (Microsoft Azure)
        • Assert components in Matillion ETL
        • Expression editors
        • Incremental load tools
        • URL safe characters
        • Generate Job Documentation
        • Jobs
        • Job concurrency
        • Notes
        • Shared jobs
        • Task management
        • Environments
        • Manage Stages
        • Multiple environment connections
        • Table properties
        • Creating a Snowflake Zero-Copy Clone
        • Create External Schema
        • Variables
        • Component Exports
        • Date and time methods
        • Environment Variables
        • Grid variables
        • Job Variables
      • Enterprise mode
      • Scope of Matillion ETL features
      • UI and basic functions
      • Admin menu
      • Schema
      • Notices
      • Search tab
      • Performance monitor
      • Views
      • Project collaboration
      • Software versions
      • Glossary
      • Manage Interpreters
        • Audit log
        • How to place restrictions on Bash and Python components
        • How to configure Catalina log rotation
        • Control session timeout expiration
        • Product improvement metrics
        • Restart server
        • Publicly available warning
        • Upgrade Tomcat version
        • Backups (AWS)
        • Backups (GCP)
        • Backups (Azure)
        • Manage backups
        • Snowflake configuration for Matillion ETL
        • Redshift configuration for Matillion ETL
        • Delta Lake on Databricks configuration for Matillion ETL
        • Configuring an AWS VPC
        • How to generate a new Databricks token
        • Snowflake key-pair authentication
        • Snowflake programmatic access token authentication
        • Configuring Matillion ETL to use a Proxy
        • Setting up an external connection to a Matillion database
        • Manage connections
        • Matillion ETL access ports
        • Configuring a connection from Matillion ETL to Maia Foundation
        • Setting up Matillion ETL in a private VPC
        • Adding a third-party JDBC driver
        • Getting started with the API driver in Matillion ETL
        • SAP Hana JDBC driver installation for Matillion ETL
        • Manage Database Drivers
        • Groups and Permissions
        • Permissions list
        • Preview Labs
        • SSL commands
        • How to add a certificate chain file for SSL configuration
        • Recreating self-signed SSL certificates on a Matillion ETL instance
        • SSL Configuration FAQ
        • Updating and migrating overview
        • Migration
        • In-place update
        • Updating to a specific release
        • Updating a high availabilty cluster
        • User configuration
          • Using stateless authentication with existing users
          • Configuring stateless authentication
          • Internal security (stateless authentication)
          • OpenID integration (stateless authentication)
          • LDAP integration (stateless authentication)
          • Stateless authentication rollback steps
          • OpenID overview
          • Microsoft Entra ID OpenID setup
          • Google OpenID setup
          • Microsoft Active Directory OpenID setup
          • Okta OpenID setup
          • OneLogin OpenID setup
          • OpenID setup
          • Troubleshooting OpenID setup
          • LDAP integration
          • Okta LDAP Configuration
        • Read-only users
        • Reverting from external to internal security
      • Matillion ETL security best practices
      • Using CSRF tokens to safeguard Matillion ETL instances
      • Installing DBT on Matillion ETL
      • Connecting to an external PostgreSQL database
      • Automatic security updates
      • Manage optional features
      • Launching Matillion ETL overview
      • Launching Cloud Platform Permissions
        • Launching Matillion ETL using CloudFormation Templates
        • List of CloudFormation Templates
        • Launching Matillion ETL using Amazon Machine Image
        • Launching Matillion ETL for Delta Lake on AWS
        • Launching troubleshooting (AWS)
        • Overview
        • Launching Matillion ETL from Azure Marketplace
        • Launching Matillion ETL using an Azure ARM Template
        • Launching Matillion ETL for Delta Lake on Azure
        • Launching troubleshooting (Azure)
        • Launching Matillion ETL for Snowflake - GCP
        • Launching Matillion ETL for BigQuery - GCP
        • Launching a Matillion ETL HA Cluster via AWS
        • Installing Matillion ETL using the Universal Installer (RPM install)
        • Overview
        • Launching Matillion ETL using CloudFormation Templates
        • List of Snowflake Launch Templates
        • Migrate from Snowflake Partner Connect to Matillion ETL for Snowflake
        • Launching Matillion ETL from AWS Marketplace
        • Launching Matillion ETL for Redshift from AWS Marketplace
        • List of Redshift Launch Templates
        • Converting to be an Annual Customer
        • Launching Matillion ETL via Azure CLI
        • Finding and Launching Matillion BYOL Images
      • Applying a licence
        • Create Project (Snowflake)
        • Create Project (Delta Lake on Databricks)
        • Create Project (Amazon Redshift)
        • Create Project (Google BigQuery)
        • Create Project (Azure Synapse Analytics)
        • Manage Project
        • Manage Credentials
        • Manage Extract Profiles
        • Manage Passwords
        • Manage Query Profiles
        • Manage OAuth
        • Manage Schedules
        • Manage Sequences
        • Manage Shared Jobs
        • Manage Versions
        • Manage Webhook Payloads
        • Integrating Matillion ETL with secret managers
        • Manage API Profiles wizards
        • Manage External File Sources
        • Azure Queue Message configuration
        • Manage Pub-Sub configuration
        • Manage SQS Configuration
        • Manage CDC
        • Enable Manage CDC
        • Configuring a source database for CDC
        • DMS migration instances
        • Git Integration with Matillion ETL
        • Git Integration Frequently Asked Questions
        • When to choose Git
        • MergeManager
        • API Profiles Overview
        • API Query Profiles
        • API Extract Profiles
        • API Connector Wizard
        • API Profiles - Pagination
        • API Profiles - Parameters
        • API Profiles - Authentication
        • API Profiles - RSDs
        • API Profiles Example - MongoDB and DynamoDB
        • API Profiles Example - Jira Cloud
        • API Profiles Example - Salesforce Lightning
      • Switch Project
      • Using data structure variables
      • Change My Password
      • Extract to new job
      • Task History
      • Import - Export
      • Input data report
      • Manage Error reporting
      • Project user access
      • Recycle Bin
      • Job references
      • Job reference renaming
      • Databricks job compute configuration
      • Snowflake query tag configuration
      • Data staging components
      • Data stagers - support
      • Data models
      • Connecting to external services securely
        • Assert External Table
        • Assert Scalar Variables
        • Assert Table
        • Assert View
        • Print Variables
        • Connectors overview
        • Acquiring Azure Credentials
          • Amplitude Extract
          • Amplitude Extract authentication guide
          • Anaplan Bulk
          • Anaplan Bulk authentication guide
          • API Query
          • API Extract
          • API Query functions
          • Create your own Matillion ETL Extract connector
          • Populating parameters with API Query
          • Apache Hive Query
          • Apache Spark SQL Query
          • Azure SQL Query
          • Azure Cosmos DB Query
          • Bing Ads Query
          • Bing Ads Query authentication guide
          • Bing Search Query
          • Bing Search Query authentication guide
          • Box Extract
          • Box Extract authentication guide
          • Cassandra Query
          • CloudWatch Publish
          • Couchbase Query
          • Data Transfer Object
          • Dropbox Extract
          • Dropbox Extract authentication guide
          • Dynamics 365 Query
          • Dynamics 365 Query Authentication Guide
          • Dynamics 365 Business Central Query
          • Dynamics 365 Business Central Query authentication guide
          • Dynamics 365 Sales Query
          • Dynamics 365 Sales Query Authentication Guide
          • Dynamics CRM Query
          • Dynamics CRM Query authentication guide
          • Dynamics NAV Query
          • DynamoDB Load
          • DynamoDB Query
          • EMR Load
          • Elasticsearch Query
          • Email Query
          • Excel Query
          • Facebook Query
          • Facebook Ads Query
          • Facebook Authentication Guide
          • Facebook Connector FAQ
          • Gmail Query
          • Gmail Query authentication guide
          • Google Ad Manager Query
          • Google Ads Query
          • Google Ad Manager Query authentication guide
          • Google Analytics Query
          • Google Analytics Query - add new data sources
          • Google BigQuery
          • Google Custom Search Query
          • Google Custom Search Query authentication guide
          • Google Drive Table
          • Google Sheets Query
          • Google Query authentication guide
          • Google third-party OAuth using Service Accounts
          • How to set your own Google Ads developer token
          • HubSpot Query
          • HubSpot Query authentication guide
          • Instagram Extract
          • Instagram Extract authentication guide
          • Instagram Business Account ID Guide
          • Intercom Extract
          • Intercom Extract authentication guide
          • Jira Query
          • Jira Query authentication guide
          • LDAP Query
          • LinkedIn Query
          • LinkedIn Query authentication guide
          • LinkedIn Ads Query
          • LinkedIn Ads Query authentication guide
          • Magento Query
          • Mailchimp Query
          • Mailchimp Query authentication guide
          • Mandrill Extract
          • Mandrill Extract authentication guide
          • Marketo Query
          • Marketo Query Authentication Guide
          • Microsoft Exchange Query
          • Microsoft Exchange Query Authentication Guide
          • MindSphere Extract
          • MindSphere Extract authentication guide
          • Mixpanel Query
          • Mixpanel Query authentication guide
          • MongoDB Query
          • NetSuite Query
          • NetSuite Query Authentication Guide
          • NetSuite SuiteAnalytics Connect
          • NetSuite SuiteAnalytics Connect Authentication Guide
          • OData Query
          • Open Exchange Rates Query
          • Open Exchange Rates Query authentication guide
          • Oracle Eloqua Query
          • Oracle Eloqua Query authentication guide
          • Pardot Extract
          • Pardot Extract authentication guide
          • PayPal Query
          • PayPal Query Authentication Guide
          • QuickBooks Online Query
          • QuickBooks Online Query Authentication Guide
          • RDS Query
          • Redis Query
          • Recurly Extract
          • Recurly Extract authentication guide
          • Sage Intacct Query
          • Salesforce Query
          • Salesforce Incremental Load
          • Salesforce Query authentication guide
          • Salesforce Bulk Query
          • Salesforce Bulk Query authentication guide
          • Salesforce Marketing Cloud Query
          • Salesforce Marketing Cloud Query authentication guide
          • Salesforce Output authentication guide
          • SAP NetWeaver Query
          • SAP NetWeaver Query - add new data sources
          • SAP ODP Extract
          • SAP ODP connection options
          • SAP ODP troubleshooting
          • SAP ODP FAQ
          • SendGrid Query
          • SendGrid Query authentication guide
          • ServiceNow Query
          • ServiceNow Query authentication guide
          • SharePoint Query
          • SharePoint Query authentication guide
          • Shopify Query
          • Shopify Query Authentication Guide
          • Snapchat Extract
          • Snapchat Extract authentication guide
          • Splunk Query
          • Database Query
          • JDBC Incremental Load
          • Square Query
          • Square Query authentication guide
          • Stripe Query
          • Stripe Query authentication guide
          • Sugar CRM Query
          • SurveyMonkey Query
          • SurveyMonkey Query authentication guide
          • Twilio Query
          • Twilio Query authentication guide
          • Twitter Query
          • Twitter Query authentication guide
          • Twitter Ads Query
          • Workday Extract
          • Workday Custom Reports
          • Workday Extract authentication guide
          • Workday Integration System User setup
          • Finding a Workday object's integration ID
          • Managing access to data sources
          • Xero Query
          • Xero Query authentication guide
          • YouTube Query
          • YouTube Analytics Query
          • Zendesk Support Query
          • Zendesk Talk Query
          • Zendesk Support/Talk Query authentication guide
          • Zendesk Chat Extract
          • Zendesk Chat Extract Authentication Guide
          • Zoho CRM Query
          • Zoho CRM Query authentication guide
          • Zuora Query
          • Zuora Bulk Query
          • Zulk Query and Bulk Query authentication guide
        • Output components overview
        • Oracle Output
        • Microsoft SQL Server Output
        • Salesforce Output
        • Pardot Output
        • Intercom Output
        • Azure SQL Bulk Output
        • RDS Bulk Output
          • S3 Load
          • S3 Manifest Builder
          • S3 Unload
          • Azure Load Snowflake
          • Azure Load Delta Lake
          • Azure Load Synapse
          • Azure Unload
          • Cloud Storage Load
          • Cloud Storage Unload
        • External Schema and Tables
          • Alter External Table
          • Create External Table
          • Refresh External Table
          • Alter Table
          • Alter Warehouse
          • Assign Tag
          • Alter Masking Policy
          • Create File Format
          • Create Stream
          • Add Partition
          • Alter Session WLM Slots
          • Analyze Tables
          • Create External Table
          • Delete Partition
          • Nested Data Load
          • Refresh Materialized View
          • Schema Copy
          • Text Output
          • Delta Live Streaming
          • Optimize
          • Refresh Table
          • Run Delta Live Table
          • Start Cluster
          • Create External Table
          • Refresh Materialized View
          • Alter Database
          • Create External Table
        • Create Table
        • Delete Table
        • SQL Script
        • Truncate Table
        • Vacuum Table
        • Flow components overview
          • Iterator components
          • File Iterator
          • Fixed Iterator
          • Grid Iterator
          • Loop Iterator
          • Table Iterator
          • Begin
          • Commit
          • Rollback
        • And
        • End Failure
        • End Success
        • If
        • Or
        • Retry
        • Run Orchestration
        • Run Transformation
        • Start
        • Load generators overview
        • Azure Blob Load Generator
        • Cloud Storage Load Generator (Snowflake)
        • Cloud Storage Load Generator (BigQuery)
        • S3 Load Generator (Snowflake)
        • S3 Load Generator (Redshift)
        • S3 Load Generator (Delta Lake)
        • SQS Message
        • SNS Message
        • PubSub
        • Azure Queue Storage Message
        • Webhook Post
        • Bash Script
        • Python Script
        • Sync File Source
        • Commands for dbt Core
        • Python Script additional settings
        • Run Notebook
        • CDC shared jobs overview
        • Sync All Tables shared job
        • Sync Single Table shared job
        • Create or Refresh External Table shared job
        • Drop CDC Tables shared job
        • Data typing with CDC shared jobs
        • Tables created
        • Append metadata
        • Append To Grid
        • Describe To Grid
        • Show to Grid
        • Query Result To Grid
        • JDBC Table Metadata To Grid
        • Query Result To Scalar
        • Remove From Grid
        • Table Metadata To Grid
      • Load generators overview
      • Send Email
        • Except
        • Intersect
        • Join
        • Unite
        • Fixed Flow
        • Generate Sequence
        • Multi Table Input
        • Stream Input
        • Table Input
        • Wildcard Table Input
        • Aggregate
        • Calculator
        • Construct Struct
        • Construct Variant
        • Convert Type
        • Table Delete Rows
        • Detect Changes
        • Distinct
        • Extract Nested Data
        • Filter
        • First-Last
        • Flatten Variant
        • Lead-Lag
        • Map Values
        • Pivot
        • Rank
        • Rename
        • Replicate
        • Split Field
        • SQL
        • Transpose Columns
        • Transpose Rows (Snowflake)
        • Transpose Rows
        • Unpivot
        • Window Calculation
        • Copy Table To External Schema
        • Create View
        • External Table Output
        • Rewrite External Table
        • Rewrite Table
        • Table Output
        • Table Update
        • API v1 - API extract profile
        • API v1 - API profile
        • API v1 - Audit
        • API v1 - Credentials
        • API v1 - Driver
        • API v1 - Environment
        • API v1 - Git integration for projects
        • API v1 - Git integration for shared jobs
        • API v1 - Group/project
        • API v1 - License
        • API v1 - Metadata
        • API v1 - Notice
        • API v1 - OAuth
        • API v1 - Passwords
        • API v1 - Permission
        • API v1 - Queue
        • API v1 - Schedules
        • API v1 - Running jobs
        • API v1 - Shared jobs
        • API v1 - Tasks
        • API v1 - Userconfig
        • API v1 - Versions
        • API v1 - Webhookpayloadprofile
        • API v1 - Secret manager
      • Matillion ETL API - v1
      • Maps of Matillion API v1
      • Getting started with Postman
      • Getting started with cURL
      • Managing users, passwords, groups, and permissions
      • Authenticating Matillion REST API bearer token
      • Obtaining an API token and passing it to an API Query profile
        • Matillion ETL API - v0
        • v0 examples
      • Authorization and authentication
      • Setting up Let's Encrypt for SSL on a Matillion ETL Instance
        • Snowflake role privileges with Matillion ETL
        • Snowflake optimization for Matillion ETL
        • Attaching AWS IAM roles To EC2 instances
        • IAM roles & permissions (AWS)
        • Custom IAM roles for Amazon Redshift
        • Changing EC2 instance size
        • IAM roles & permissions (GCP)
        • GCP service accounts
        • BigQuery data set setup
        • GCP enabling APIs
        • Changing Azure instance size
        • Roles & permissions (Azure)
        • Configuring a high availability cluster (Azure)
          • Getting Started with Amazon Redshift Spectrum
          • Using Spectrum in Matillion ETL
        • Accessing files in S3 using Pre-signed URLs
        • Automating Redshift maintenance
        • AWS S3 lifecycle rule
        • Cross-account S3 access
        • Parallelism with Matillion ETL for Redshift
        • Snowflake AWS Storage Integration setup guide
        • Snowflake Azure Storage Integration setup guide
        • Troubleshooting connection to Azure Blob Storage
        • Creating secrets in Azure Key Vault
        • Snowflake GCP Storage Integration setup guide
          • Adding filename as a column to tables (BigQuery)
          • Adding Filename as a column to new table
          • Populating an audit table
        • Building a data vault
        • Building a data vault (Snowflake)
        • Data transfer between databases
        • Ingesting AWS ElasticSearch data via the API Query component
        • Year-on-year analysis
        • Designing a job for a high availability cluster
        • Incremental or high water mark data Loading
        • Microbatch replication
        • How to receive emails by subscribing to a cloud Pub/Sub topic
        • Flattening nested arrays
        • Changing the host file
        • How to configure SSL protocols
        • Outbound IP requirements
        • Triggering ETL from an S3 event via AWS Lambda
        • Triggering ETL from an email via SES and Lambda
        • Triggering ETL from Amazon Alexa via AWS Lambda & Amazon SQS
        • Triggering a Matillion ETL job from your Google Home device
        • Triggering Matillion ETL from a storage queue via an Azure function
      • Collibra integration
      • Connecting to an RDS in a private VPC
      • Diagnostic data policy
      • Executing Python scripts outside of Matillion
      • Helping with the GDPR
      • Integrating Slack with Matillion ETL
      • Using grid variables to apply business rules in a transformation job
      • Making multiple API queries
      • Matillion data quality framework
      • NRT replication In Redshift
      • Pivoting and unpivoting tables
      • SCM integration
      • Tracking loaded files
      • Using incron to automatically copy data to S3
      • Using KMS encrypted passwords in Python
      • Using R with Matillion ETL for Redshift
      • Using Table Metadata to Grid
      • Managing Python on a Matillion ETL virtual machine (VM)
      • How to retrieve missing Task History entries after 1.47 upgrade
      • Matillion Exchange
      • Maia features
      • Upgrade process
      • Upgrade considerations
      • Set up your Maia Foundation account
      • Import your jobs into Maia Foundation
      • Import shared jobs
      • Decommission Matillion ETL
        • Feature differences in Maia Foundation
        • Upgrade - API Extract
        • Upgrade - API Query
        • Upgrade - Automatic variables
        • Upgrade - Bash
        • Upgrade - Database Query
        • Upgrade - dbt
        • Upgrade - Export variables
        • Upgrade - Extract Nested Data
        • Upgrade - Filter
        • Upgrade - Iterator components
        • Upgrade - Python
        • Upgrade - Replicate
        • Upgrade - Temporary tables
        • Upgrade - Text Output
        • Upgrade - Transactions
        • Upgrade - Variables
      • Release notes index
      • Support lifecycle
      • Supported releases
      • 1.80 (LTS) release notes
      • 1.79 release notes
      • 1.78 (LTS) release notes
      • 1.77 release notes
      • 1.76 release notes
      • 1.75 (LTS) release notes
      • 1.74 release notes
      • 1.73 release notes
      • 1.72 release notes
      • 1.71 release notes
      • 1.70 release notes
      • 1.69 release notes
      • 1.68 release notes
      • 1.67 release notes
      • 1.66 release notes
      • 1.65 release notes
      • 1.64 release notes
      • 1.63 release notes
        • Matillion ETL for Snowflake release notes
        • Matillion ETL for Redshift release notes
        • Matillion ETL for BigQuery release notes
        • Matillion ETL for Synapse release notes
        • Matillion ETL for Delta Lake release notes
      • Release notes advisories
      • Release notes archive
      • Tech note - Base OS vulnerability
      • Critical Advisory - Mandatory update required to address Licence Management Defect
      • Tech note - Salesforce certificate update
      • Tech note - Base OS change to openSUSE
      • Tech note - Adjusting Tomcat memory for Matillion ETL upgrades
      • Tech note - Snowflake to block single-factor password authentication
      • Tech note - Image scanning for CVEs
      • Tech note - Removal of Manage CDC
      • Tech note - AWS thread count increases leading to failing instances
      • Tech note - user configuration and security best practices update
      • Tech note - AWS SDK upgrade for Java
      • Tech note - 1.68 update failure
      • Tech note - automatic security updates
      • Tech note - Snowflake GCP update
      • Tech note - legacy key algorithm constraints
      • Tech note - OutOfMemory events in version 1.69
      • Tech note - Redshift RingBuffer exceeding expected limits
      • Tech note - disk partition sizing for versions 1.69-1.72
      • Updating to version 1.69 and above
      • Technology upgrade of PostgreSQL
      • Tech note - running Query components through a proxy server
      • Tech note - Shopify Query versioning
      • Tech note - Splunk Query versioning
      • Tech note - Google Analytics driver update
      • Tech note - Postgres driver for Amazon Redshift
      • Security Advisory - Spring4Shell
      • Tech Note - Google Ads updates in v1.62
      • Updating to version 1.60 and above
      • Security Advisory - v1.59.11
      • Security Advisory 13th Jan 2022
      • Security Advisory 17th Dec 2021
      • Security Advisory 14th Dec 2021
      • Tech Note 15th June 2021
      • Tech Note 14th May 2021
      • Potential credentials in Matillion ETL log file
      • Tech Note 10th February 2021
      • Tech Note 28th January 2021
      • Tech Note 12th November 2020
      • Tech Note 22nd September 2020
      • Tech note 22nd June 2020
    • Getting support

Azure blob storage role

To stage data to Azure Blob Storage, the Azure credentials associated with your environment must be assigned the Storage Blob Data Contributor role. For more information, read User assigned with the Storage Blob Data Contributor role.

© Copyright 2026 Matillion Ltd | Legal | Privacy Policy | Disclaimer | Modern Slavery Statement