Microsoft Azure Data Lake Store

Version:
2019.3
Last modified: September 26, 2019
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.

Type of Support

Read & Write

Validated On

--

Alteryx tools used to connect

 

Link
Gray icon with file folder

ADL File Input Tool

Link
Gray icon with file graphic inside

ADL File Output Tool

Additional details

  • If in a state without access (read/write) to a certain folder created by another account, this is due to permissions.
  • If you encounter an error that states the token may have been revoked, you must log out/back in to the configuration panel to reauthenticate.
    • Note: Token lifetime properties are configurable by the System Administrator.

 

Access permissions

The Azure Data Lake Explorer must grant permissions to read and write data within an Azure Data Lake Store account. For more information about how these permissions are assigned and applied, see the official Microsoft documentation.

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.

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.