Azure Data Lake Storage

Azure Data Lake Storage is a massively scalable and secure data lake for your high-performance analytics workloads.

Establishing Connection

To create a connection to Azure Data Lake Storage, you need to select the authentication method: OAuth 2.0, Account Access Key or SAS Token.

Getting Credentials

Tenant ID for OAuth 2.0

To obtain the Tenant ID, follow these steps:

  1. In your Azure account, click the User icon in the top-right corner and select Switch directory:

    User icon

  2. Locate the ID of the current directory on the Directories + subscriptions page:

    Directory ID

  3. Copy the Directory ID and paste it into the Tenant ID field.

Account Access Key

To obtain the Account Access Key, perform the following steps:

  1. Under resources, select your storage account.
  2. From the resource menu, under Security + networking, select Access Keys.

    Access Keys

  3. Click Show to reveal your access key. Copy it.

SAS Token

To obtain the SAS Token, perform the following steps:

  1. Under resources, select your storage account.
  2. From the resource menu, under Security + networking, select Shared access signature.

    Shared access signature

  3. You can adjust the permissions to your needs, but the following parameters should be enabled:
    • Allowed services: Blob;
    • Allowed resource types: Container;
    • Allowed permissions: Read, Create;
  4. Click Generate SAS and connection string. Copy the token.

Creating OAuth 2.0 Connection

To connect to Azure Data Lake Storage, perform the following steps:

  1. Enter the Storage Account Name and Tenant ID.

    OAuth 2.0

  2. Click Sign in with Microsoft.
  3. In the sign-in window, choose your preferred method (email, phone, or Skype) and click Next:

    Sign in window

  4. Grant the necessary permissions by clicking Accept:

    Permissions

Creating Connection Using Account Access Key

To create a connection, specify the Storage Account Name and Account Access Key.

Account Access Key

Creating Connection Using SAS Token

To create a connection, specify the Storage Account Name and SAS Token.

SAS Token

Connector Specifics

You can use this connector to access Azure Blob Storage via OAuth 2.0. However, Skyvia offers a dedicated Azure Blob Storage connector specifically for this purpose.