Skip to main content
Prerequisites To follow this guide, you will need:
2

Select the data source

Select Azure Blob Storage as data type
3

Setup your ClickPipe 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” for more details.Finally, click Incoming data
4

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
5

Configure table, schema and settings

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
When you have finished configuring your table, schema and settings, click Details and settings
6

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”.
7

Complete setup

Click Create ClickPipe to complete setupYou should now see your ClickPipe in a provisioning status. After a few moments it will change from provisioning to completed.
Last modified on July 10, 2026