Azure Data Lake File Input Tool

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.

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.

• 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 (/).
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
• 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.