Azure Blob Storage

Connect an Azure Blob Storage container so Qubit can load CSV or Parquet files from a folder on a schedule. All files in the folder load into one table.

How files become tables

• Every CSV or Parquet file under the folder you enter loads into a single table named after the folder.
• The first file defines the table's columns, so keep the same columns in every file in the folder.
• To load another folder as its own table, create another connection.

Before you start

In the Azure portal, open your storage account, go to Access keys, and copy a connection string.

Connect Azure Blob Storage

1. Open Data Catalog from the sidebar, click Add Data, then choose Connect a database.
2. On the New Data Source page, click Azure Blob. It is under Cloud Storage.
3. Enter a Connection Name.
4. Fill in the fields:
   • Connection String: the storage account connection string.
   • Container Name: the container that holds your files.
   • Folder (prefix): required. The folder path inside the container, for example exports/orders/.
5. Choose a Sync Schedule. The default is Daily.
6. Click Create.

After you connect

Qubit checks that the required fields are filled in, saves the connection, and starts the first sync. It confirms that it can read the container during that sync.

To check the connection at any time, open its menu in the Data Catalog and choose Test connection. If Last sync shows Failed, hover over it to see the reason, correct the details with Edit, then choose Sync now.