> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-detect-table-modification.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Step-by-step guide to create your first Azure Blob Storage (ABS) ClickPipe.

# Create your first Azure Blob Storage ClickPipe

export const Image = ({img, alt, size = "lg"}) => {
  const normalizedSize = ["sm", "md", "lg"].includes(size) ? size : "lg";
  return <div className={`ch-image-${normalizedSize}`}>
      <Frame>
        <img src={img} alt={alt} />
      </Frame>
    </div>;
};

**Prerequisites**

To follow this guide, you will need:

* An Azure Blob Storage account
* [Azure connection string](/integrations/connectors/data-ingestion/azure/azure-data-factory/using-azureblobstorage#acquiring-azure-blob-storage-access-keys)
* Container name
* A running ClickHouse Cloud service

<Steps>
  <Step title="Navigate to data sources" id="navigate-to-data-sources">
    From the home page of your service, click **Data sources** in the left hand menu.
    Expand the **ClickPipes** dropdown and click **Create ClickPipe**

    <Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/Qdrmbc1T54ihl0_n/images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/01-navigate-to-datasources.webp?fit=max&auto=format&n=Qdrmbc1T54ihl0_n&q=85&s=112a561a80cd4b1237e3f1979fdd07bd" alt="Navigate to Data Sources" size="md" width="1702" height="1030" data-path="images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/01-navigate-to-datasources.webp" />

    <Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/Qdrmbc1T54ihl0_n/images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/02-create-clickpipe.webp?fit=max&auto=format&n=Qdrmbc1T54ihl0_n&q=85&s=71d1955cd6a347117cbb239936b8585f" alt="Create ClickPipe" size="md" width="1134" height="390" data-path="images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/02-create-clickpipe.webp" />
  </Step>

  <Step title="Select the data source" id="select-data-source">
    Select **Azure Blob Storage** as data type

    <Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/Qdrmbc1T54ihl0_n/images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/03-select-blob-storage.webp?fit=max&auto=format&n=Qdrmbc1T54ihl0_n&q=85&s=867c64d946143d7fd9e5b7fe9ccb22d2" alt="Select Azure Blob Storage" size="md" width="1194" height="624" data-path="images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/03-select-blob-storage.webp" />
  </Step>

  <Step title="Setup your ClickPipe connection" id="setup-connection">
    1. Give your ClickPipe a descriptive name
    2. Select **Connection String** from the authentication method dropdown
    3. Paste your Azure connection string in the field for **Connection string**
    4. Enter your container name
    5. Enter your Azure Blob Storage file path, using wildcards if you want to ingest multiple files

    Optionally, enable continuous ingestion. See ["Continuous Ingestion"](/integrations/clickpipes/object-storage/azure-blob-storage/overview#continuous-ingestion) for more details.

    Finally, click **Incoming data**

    <Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/Qdrmbc1T54ihl0_n/images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/04-configuration-details.webp?fit=max&auto=format&n=Qdrmbc1T54ihl0_n&q=85&s=32d9a1b9d50c7660481e0c5d47e18c44" alt="Configuration Details" size="md" width="1226" height="842" data-path="images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/04-configuration-details.webp" />
  </Step>

  <Step title="Select data format" id="select-data-format">
    1. Select file type
    2. File compression (`detect automatically`, `none`, `gzip`, `brotli`, `xz` or `zstd`)
    3. Complete additional format specific configuration such as delimiter used for comma-separated formats
    4. Click **Parse information**

    <Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/Qdrmbc1T54ihl0_n/images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/05-choose-data-format.webp?fit=max&auto=format&n=Qdrmbc1T54ihl0_n&q=85&s=c3eb1b7db9743d4c87f0e03efa8e4b25" alt="Choose Data Format" size="md" width="1214" height="624" data-path="images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/05-choose-data-format.webp" />
  </Step>

  <Step title="Configure table, schema and settings" id="configure-table-schema">
    Now you need to create a new table or select an existing one where the incoming data can be stored.

    1. Select whether to upload data to a new table or an existing table
    2. Select the database to use, and which name to give the table if it is a new table
    3. Choose a sorting key or keys
    4. Define any mappings from the source file to destination table for column name, column type, default value and nullability
    5. Finally, specify advanced settings such as the engine type you wish to use, the expression to partition by and the primary key

    <Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/Qdrmbc1T54ihl0_n/images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/06-parse-information.webp?fit=max&auto=format&n=Qdrmbc1T54ihl0_n&q=85&s=ba3721ea1cef984cbbe01211779433a6" alt="Parse Information" size="md" width="1212" height="1434" data-path="images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/06-parse-information.webp" />

    When you have finished configuring your table, schema and settings, click **Details and settings**
  </Step>

  <Step title="Configure permissions" id="configure-permissions">
    ClickPipes will set up a dedicated database user for data writing.
    You can select a role for this user.
    For materialized views or dictionary access from the destination table, opt for "Full access".

    <Image img="https://mintcdn.com/private-7c7dfe99-detect-table-modification/Qdrmbc1T54ihl0_n/images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/07-permissions.webp?fit=max&auto=format&n=Qdrmbc1T54ihl0_n&q=85&s=0e334833b5fb51188dce64db435d47c9" alt="Configure Permissions" size="md" width="1186" height="548" data-path="images/integrations/data-ingestion/clickpipes/object-storage/azure-blob-storage/07-permissions.webp" />
  </Step>

  <Step title="Complete setup" id="complete-setup">
    Click **Create ClickPipe** to complete setup

    You should now see your ClickPipe in a provisioning status.
    After a few moments it will change from **provisioning** to **completed**.
  </Step>
</Steps>
