Azure Blob Storage

Setting up your Azure Blob Storage destination.

Creating a Azure Blob Storage Destination.

From the UI

You can create a new Azure Blob Storage destination from your DCN by going to the Integrations -> Destinations section in your navigation menu.

Destinations Catalog

To add your Azure Blob Storage bucket, you will need to enter the name of this destination (this is how your destination will appear when exporting audiences), the Azure Tenant ID, Client ID, Client Secret & Bucket URL.

Adding Your Azure Destination

Once created, you will be automatically redirected to the destinations listing page.

Exporting Audiences to Azure.

From the UI

To export to your Azure destination, navigate to the audience you want to export and click "Export" in the top right. In this form you can select the Azure destination you previously created.

Exporting an Audience to Azure

On this page, you have the option to export your audience in either CSV or TSV format. You can also choose between exporting individual IDs or ID clusters, and select which IDs you want to export, along with other export options. To complete the export process, simply enter a name for the file that will be saved to your Azure Blob Storage container.

From the CLI

From the CLI, enter the following:

optable-cli export create file <audience-id> <destination-id> <filename> <format>

Where:

  <audience-id>       Audience to export.
  <destination-id>    Destination of the export.
  <filename>          Filename of the Export on the destination.
  <format>            Format to use for export (id_csv, id_tsv, cluster_json).

You can choose which ID to send with:

--identifiers-filter=IDENTIFIERS-FILTER,...
                             Filter identifiers by type. Options are: idfa,
                             gaid. Defaults to all types if omitted.

Here is an example of what your command should look like:

$ optable-cli export create file 114 7 "myfile.csv" "id_csv"

Here is an example of the expected CLI output:

{
  "id": 95,
  "created_at": "2022-09-28T14:40:22.878863747Z",
  "updated_at": "2022-09-28T14:40:22.878863747Z",
  "destination": {
    "id": 7,
    "kind": "DESTINATION_KIND_S3",
    "created_at": "2022-09-28T14:27:46.412692Z",
    "updated_at": "2022-09-28T14:27:46.412692Z",
    "name": "destinationfromCLI",
    "state": "DESTINATION_STATE_ACTIVE"
  },
  "audience": {
    "id": 114,
    "name": "myAudience",
    "kind": "AUDIENCE_KIND_QUERY",
    "created_at": "2022-07-15T17:53:29.255148Z",
    "updated_at": "2022-07-15T17:56:27.565118Z",
    "insights_computed_at": "2022-09-07T14:03:06.979720Z",
    "state": "AUDIENCE_STATE_ACTIVE",
    "activation": {
      "keyword": "48dcdse8ff"
    }
  },
  "state": "EXPORT_STATE_PENDING",
  "identifiers_filter": [
    "ID_KIND_EMAIL_HASH",
    "ID_KIND_APPLE_IDFA",
    "ID_KIND_GOOGLE_GAID",
    "ID_KIND_CUSTOM_ID",
    "ID_KIND_VISITOR_ID",
  ],
  "file": {
    "filename": "myfile.csv",
    "override_existing": true,
    "export_metadata": true,
    "id_format": {
      "kind": "ID_FORMAT_KIND_CSV",
      "type_column": true,
      "include_header": true
    }
  },
  "filename": "myfile.csv",
  "override_existing": true,
  "export_metadata": true,
  "id_format": {
    "kind": "ID_FORMAT_KIND_CSV",
    "type_column": true,
    "include_header": true
  }
}

What Can I Export to Azure?

You can export IDs only or ID clusters. All ID types are supported by this destination type. Exports to this destination also have the following optional settings:

• Include the header row.

• Include values prefixed with type indicator.

• ID type in second column.

• Export an additional METADATA file

How will my Export Appear in Azure?

Your export will appear in your Azure Blob Storage container bucket with the file name you set during export creation.

If you choose to re-export an audience with the same name, it will overwrite the existing file in your storage bucket. However, if you opt for a filename that does not currently exist, a new file will be created upon export.