Gray icon with file folder

ADL File Input Tool

Last modified: December 23, 2019

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

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

Tool Configuration

  1. Open the Configuration window for the ADL File Input tool.
  2. In Tenant ID, define the unique identifier for the Azure Active Directory instance. This identifier governs the Azure subscription to which the ADLS belongs. or more information about locating your tenant ID, see Get tenant ID in the Microsoft Azure Documentation.
  3. From Authentication type, select one of the following authentication methods to use with Azure Active Directory:
    • Service-to-Service: An authentication method leveraging an Azure Active Directory web application to enable a connextion and schedule workflows.
      • Enable a connection and schedule workflows with ADLS
        • In Client ID, enter the application ID for the Azure Active Directory web application.
        • In Secret key, enter the application key for the Azure Active Directory web application. For help in locating the application ID and secret key, see Get application ID and authentication key in the Microsoft Azure Documentation.
    • End User: An authentication method leveraging Microsoft account credentials to establish a connection.
      • Establish a connection to ADLS
        • In User name, enter the user name for the Microsoft account that has access to the ADLS. A user name is typically the email address associated with the account.
        • In Password, enter the password associated with the Microsoft account.
  4. In Store name, enter the unique name given to the ADLS account. The store name is the first portion of the ADLS full domain name.
    • Example: The store name is italicized in the following full domain name.
  5. In Source file path, enter the full path to a file in the ADLS. Make sure to begin the path with a slash (/). 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
  6. From File format, select CSV, JSON, or Avro. For additional information about steps needed for the selected file format, see File Format Options.
Was This Helpful?

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