Use the Azure Data Lake Store (ADLS) Input to read data from files located in your ADLS to your Alteryx workflow and Azure Data Lake Store (ADLS) Output to write data to files in your ADLS. The supported file formats are CSV, Excel, JSON, and Avro.
Current version
Compatible with Alteryx Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later.
Requires AMP engine.
Alteryx Server requires stored credentials in DCM to run workflows.
Fixed issue where ADLS Tools read and wrote string values as “None” and integer values as “NAN”. (TPM-2211, TPM-2170)
Fixed issue where ADLS Input returned Malformed CSV file error. ADLS Input now returns a more descriptive message. (TPM-2173)
Fixed issue where ADLS Tools didn’t correctly parse custom delimiters and quote characters. (TPM-2108, TPM-2098)
Previous versions
Improved write performance and stability.
Added option to tweak memory consumption and performance by modifying variable upload chunk size.
Fixed issue where XLSX data were truncated when cells contained more than 255 characters.
Fixed issue with non-Unicode characters in SSL certificates.
Compatible with Designer and Server 2021.4.2 Patch 4, 2022.1 Patch 2 and later.
Compatible with AMP engine only.
- Added support for DCM.
- DCM is required for running this connector in Alteryx Server.
FIPS capable.
SSL/TLS validation is now performed against Windows Certificate Store.
Updated Code Page options.
Distinguished between encodings with same language (e.g., ‘Language’ -> ‘Language (specific code)’) and ordered encodings alphabetically.
Allowed user to specify encoding for CSV files on output tool.
Improved error message to indicate when an invalid store name is provided.
Improved data conversion handling to not throw a warning instead of an error when a field is missing a value.
Fixed error where the files/folders displayed are not refreshed after user changes store name.
Fixed issue where default value settings were occasionally not respected.
- Disabled production logging to prevent permissions issues for different installations/configurations of Designer and support scheduled workflow functionality.
- Fixed issue preventing packages from being installed successfully.
- Initial release for Azure Data Lake File Input and Azure Data Lake File Output.
This tool uses a .yxi file format. A .yxi file is a package that includes an Alteryx Tool and all of its dependencies zipped into a single file. When this file is imported into Alteryx, the tool is added to the tool palette in the category specified by the tool.
When sharing a workflow that uses a .yxi tool, the tool is not included and must be installed by the recipient.
