Azure Data Lake Storage Gen2

Description

A connector used for importing data to and from Azure Data Lake Storage Gen2.

Task Type Support

This connection type supports the following task types:

  • Data Migration

Data Migration Support

This connection can be used in a Data Migration.

Usable as Source Usable as Target Usable as Incremental Source Usable as Incremental Target

Connection String Templates

Template Name Description
Azure Data Lake Storage Gen2 The standard connection string for Azure Data Lake Storage Gen2, that also requires an Account Access Key.

Connection Notes

  • The connection string for Azure Data Lake Storage Gen2 is an account access token that you can generate from within the Azure Portal.

  • Please note that a file definition that uses this connection needs to specify a particular container or a directory in the container as the path. If you specify a container or directory in your path that does not yet exist, it will be created in the Azure Data Lake Storage Connection when the task using it is run.

  • When exporting into Parquet, if it is not specified in the connection string, Azure Data Lake Storage will default to a LOCAL offset value for any datetime offset columns. You can change the format of the datetime offset using the configuration settings here and adding it to your connection string.