Microsoft Azure Data Lake File Input Tool Icon

Microsoft Azure Data Lake File Input Tool

Version:
Current
Last modified: March 20, 2020

Use the Azure Data Lake Store (ADLS) File Input tool to read data from files located in your ADLS to your Alteryx workflow. The supported file formats are CSV, JSON, and Avro.

Gallery Tool

This tool is not automatically installed with Alteryx Designer. To use this tool, download it from theĀ Alteryx Analytics Gallery.

Configure the Tool

There are two different authentication types.

  1. End user - An authentication method leveraging Microsoft account credentials to establish a connection to ADLS. This authentication type requires user interaction when entering in your credentials.
    1. Authentication requires:
      1. Store name - The unique name of the Azure Data Lake Storage resource.
      2. Tenant ID - The unique identifier to be defined for the Azure Active Directory instance. This identifier governs the Azure subscription to which the ADLS belongs.
      3. Client ID - The application ID for the Azure Active Directory native application.
      4. Redirect URI - The Reply URI or Reply URL, also known as the URI at which the Azure AD will send a response to complete the authentication process.
      5. Default value is https://login.live.com/oauth20_desktop.srf

        A token could expire or be revoked, causing the workflow to fail to authenticate properly.

      The Azure application must be a native application in order to use end-user authentication within Alteryx.

  2. Service-to-Service - An authentication method recommended for workflows that are scheduled and need to run without user interaction.
    1. Authentication requires:
      1. Store name - The unique name of the Azure Data Lake Storage resource.
      2. Tenant ID - The unique identifier to be defined for the Azure Active Directory instance. This identifier governs the Azure subscription to which the ADLS belongs.
      3. Client ID - The application ID for the Azure Active Directory native web application.
      4. Secret Key - The application secret for the Azure Active Directory web application.

The Connect button will be enabled when all required information has been entered.

If you are unsure of the file path, you can use Azure Data Lake Explorer or Azure Portal to determine the file path.
/Folder1/Folder2/example_file.csv

  • File path: Select a file to read. Enter the full path that leads to a file in the ADLS, making sure to begin the path with a slash (/).
    • From File format, select CSV, JSON, or Avro. For additional information about steps needed for the selected file format, see File Format Options.
  • File format: The file format; CSV/Avro/JSON.
  • Maximum field length: The maximum length of a column (field header and record).
  • Field delimiter: The character to delimit by.
    • The first row contains names. Checking this box in the configuration panel states that the first row contains the field names.
    • The first row contains the names that were checked, and will begin reading data on line 1. The first row will be read as field names.
      • Quote character: A character that should be treated as a quote.
      • Code page: A decoding scheme to use when reading the file.

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, please visit the official Microsoft documentation.

Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.