ADL File Output Tool

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

Configure the tool

1. Open the Configuration window for the ADL File Output 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.

For 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 establish a connection and schedule workflows.
   Establish a connection and schedule workflows with ADLS

   1. In Client ID, enter the application ID for the Azure Active Directory web application.
   2. 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
   1. 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.
   2. 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 shown as blue text in the following full domain name.

mydatalakestore.azuredatalakestore.net

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 either CSV, JSON, or Avro. For additional information about steps needed for the selected file format, see File Format Options.
7. From Existing file action, select one of the following options to determine how the output tool behaves when a file already exists at the specified file path.
• Overwrite: The output tool overwrites the file with the data from the Alteryx workflow.
• Append: The output tool appends data from the Alteryx workflow to the file.
• Abort: The output tool ends the Alteryx workflow with an error.