Set Up Azure Data Lake Storage

This tutorial explains how to configure Azure Data Lake Storage (ADLS) as your destination using the Fivetran Managed Data Lake Service. It walks through the required Azure setup, Fivetran configuration, and how to validate data ingestion.

Watch the video

What you will learn

This tutorial covers the following steps:

Configure Azure Data Lake Storage

• Create or select an Azure Data Lake Storage Gen2 account
• Enable hierarchical namespace
• Create a container for storing data lake files

Configure authentication and access

• Register an application in Azure Active Directory
• Generate a client ID and client secret
• Grant the required permissions to access the storage account
• Apply least-privilege access principles

Configure the destination in Fivetran

• Create a new Managed Data Lake Service destination
• Select Azure Data Lake Storage
• Provide the storage account name, tenant ID, client ID, and client secret
• Specify the container name and prefix path
• Select the appropriate cloud region
• Test the connection

Ingest and validate data

• Add a connector to start data ingestion
• Verify that Fivetran writes data to the expected container and path
• Confirm schema and file structure

Understand storage formats and catalog integration

• Use the Fivetran Iceberg REST catalog with supported query engines
• Understand how data is written in Delta Lake format
• Enable downstream analytics workflows

Summary

After completing this tutorial, you will have a working Azure Data Lake Storage destination integrated with Fivetran and be able to query your data using supported analytics tools.