Load Metadata from a Microsoft Azure Data Lake Store Gen2

Version:
Current
Last modified: November 18, 2020

Use the Microsoft Azure Data Lake Store Loader to upload metadata to Alteryx Connect from a specified Microsoft Azure Data Lake Store.

As of the version 20.3, Gen1 and Gen2 loaders are supported. For more information about the Gen1 loader, visit the Load Metada from a Microsoft Azure Data Lake Store Gen1

Review Loader Requirements

The Alteryx Connect Loaders must be installed on the machine where Alteryx Server is installed. To install the loaders:

  1. Download the loaders installer. For compatibility, the Loaders installer version must match the Alteryx Connect version.
  2. Run the installer as an administrator.

Azure Data Lake Store loader requires information according to the selected Azure authentication methods, such as Tenant ID, Application ID, Authentication key, and so on. See Azure Data Lake documentation.

Open the Loader

  1. Open Alteryx Designer.
  2. Select Help > Sample Workflows Alteryx Connect Metadata Loaders > ADLSGen2 Loader > ADLSGen2 Loader.

Run the App

  1. Select Run as Analytic App Run as analytic app button.
  2. In the Azure Data Lake Store tab:

  • Select one of the Azure authentication methods and fill in the required information. 

ADLS Gen2 Authentication with a Client Certificate

When you select the Client certificate option, you need to have your public and private key prepared. 
Allowed file formats:

  • Public key: .cer, .pem, .crt
  • Private key: .pem
  1. Upload your public key to your Azure portal under Home > App registrations > Your Application > Certificates & secrets
  2. After uploading your public key, copy the Client certificate thumbprint from the Azure portal. 
  3. Switch to Designer and select HelpSample Workflows > Alteryx Connect Metadata Loaders > ADLSGen2 LoaderADLSGen2 Loader.
  4. Navigate to the Azure Data Lake Store tab to set up the loader. 
  5. Paste the Thumbprint you copied from the Azure portal to Client certificate thumbprint.  
  6. In Client private key (.pem), specify the path to your private key. 
  • Path: An absolute path to load. Leave blank to load the full structure.
  • Files to load: A comma-separated list of file types to load. Leave blank to load all file types.

    Supported file types include .csv, .xls, .xlsx, .yxdb, .xml, .twb, .tde, and .arvo.

3. In the Alteryx Connect tab, type the URL for your Alteryx Connect instance and your credentials. 

  • https://yourcompany.alteryxconnect.com
  • Before running the app, select Save button and save the app configuration to the following directory: C:\ProgramData\Alteryx\AlteryxConnect\ADLS_Loader\

The .yxwv app values file is used for scheduling the loader to run in the Gallery. See Schedule Metadata Loaders.

4. Select Finish to run the app.

Depending on how much metadata is being imported, the app can take a long time to run.

  • If the run succeeds, "Success" appears in the App Results window.
  • If the run fails, a "There were Errors" message appears.

View the Metadata

  1. Go to the Alteryx Connect URL and log in.
  2. From the main menu, select Data Sources > Files.
  3. Select your store name.
  4. Select a folder to view its contents.
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.