Microsoft Azure Data Lake Store

Type of Support:	Read & Write
Verified On:	--
Connection Type:	Alteryx Tool. The latest version is available from the Alteryx Analytics Gallery.
Driver Details:	Depending on the chosen login method, an administrator may need to configure access to Azure Data Lake and Azure Active Directory before a connection can be made using the Alteryx Azure Data Lake tools.

Alteryx tools used to connect

Additional Details

Known Limitations

Avro byte Field Type	Avro files with fields of type bytes are not supported and will fail upon import.
Output: Alteryx float Field to Avro Type Conversion	Alteryx workflow float field values are converted to double in the destination Avro file.
Multiple Connectors with Different Azure Active Directory User Accounts	The Microsoft Azure Data Lake, OneDrive, and Dynamics CRM connectors support authentication via Microsoft user credentials, such as email and password. In interactive workflows, it is not currently possible to authenticate with different Microsoft user accounts across these connectors. This limitation does not impact scheduled workflows. In the case that you are authenticated with a Microsoft user account in one of these connectors and try to authenticate to another connector with a different Microsoft user account, you will see an error message pop-up. To resolve this issue, follow on of these recommendations: • The Azure Active Directory Administrator can grant the necessary permissions to one user account and ensure the user building the workflow has one user account that has access to the services needed in that workflow. • Log out of any connectors that are authenticated to a different Microsoft user account before trying to log in. • Avoid using end user authentication when possible. Use service-to-service authentication in the Azure Data Lake connectors and Application login authentication in the Dynamics CRM connectors.

Avro byte Field Type

Avro files with fields of type bytes are not supported and will fail upon import.

Output: Alteryx float Field to Avro Type Conversion

Alteryx workflow float field values are converted to double in the destination Avro file.

Multiple Connectors with Different Azure Active Directory User Accounts

The Microsoft Azure Data Lake, OneDrive, and Dynamics CRM connectors support authentication via Microsoft user credentials, such as email and password. In interactive workflows, it is not currently possible to authenticate with different Microsoft user accounts across these connectors. This limitation does not impact scheduled workflows. In the case that you are authenticated with a Microsoft user account in one of these connectors and try to authenticate to another connector with a different Microsoft user account, you will see an error message pop-up. To resolve this issue, follow on of these recommendations:

• The Azure Active Directory Administrator can grant the necessary permissions to one user account and ensure the user building the workflow has one user account that has access to the services needed in that workflow.

• Log out of any connectors that are authenticated to a different Microsoft user account before trying to log in.

• Avoid using end user authentication when possible. Use service-to-service authentication in the Azure Data Lake connectors and Application login authentication in the Dynamics CRM connectors.