PowerExchange for Microsoft Azure Blob Storage User Guide

10.5.6
- 10.5.7
- 10.5.4
- 10.5.3
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Creating a Microsoft Azure Blob Storage Data Object

Create a Microsoft Azure Blob Storage data object to add to a mapping.

Select a project or folder in the

Object Explorer

view.

Click

File

New

Data Object

Select

Azure Blob Storage Data Object

and click

The Azure Blob Storage Data Object dialog box appears.

Enter a name for the data object.

In the

Resource Format

list, select any of the following formats:

Intelligent Structure Model: to read any format that an intelligent structure parses.

Binary: to read any resource format.

Flat: to read and write delimited resources.

Avro: to read and write Avro resources.

Json: to read and write JSON resources.

Parquet: to read and write Parquet resources.

Intelligent structure model is supported only on the Spark engine. JSON is supported in the non-native environments. Avro and Parquet are supported in the native and non-native environments.

Click

Browse

next to the

Location

option and select the target project or folder.

Click

Browse

next to the

Connection

option and select the AzureBlob connection from which you want to import the Microsoft Azure Blob Storage object.

To add a resource, click

Add

next to the

Selected Resources

option.

The Add Resource dialog box appears.

Navigate through the container structure and select the checkbox next to the Microsoft Azure Blob Storage object you want to add and click

You must select the object according to the selected resource format. To use an intelligent structure model, select the appropriate

.amodel

file.

Click

Finish

if you selected Intelligent Structure Model, Avro, Json, or Parquet file and skip the remaining steps. Click

if you selected a flat file.

Applicable only to the delimited files. Choose

Sample Metadata File

You can click Browse and navigate to the directory that contains the file.

Click

Configure the format properties.

Property	Description
Delimiters	Character used to separate columns of data. Make sure that the delimiter you select is not a part of the data. If you enter a delimiter that is the same as the escape character or the text qualifier, you might receive unexpected results. Microsoft Azure Blob Storage reader and writer support Delimiters.
Text Qualifier	Quote character that defines the boundaries of text strings. Make sure that the text qualifier you select is not a part of the data unless it is escaped. If you select a quote character, the Developer tool ignores delimiters within pairs of quotes. Microsoft Azure Blob Storage reader supports Text Qualifier.
Import Column Names From First Line	If selected, the Developer tool uses data in the first row for column names. Select this option if column names appear in the first row. Do not select this option to read header-less files. Applicable only to the native environment.

Click

to configure the column properties and edit the column attributes.

Click

Finish

The data object appears under Data Objects in the project or folder in the Object Explorer view. The data object read and write operations are created by default when a data object is created.

When you create a Microsoft Azure Blob Storage data object, the value of the folder path is displayed incorrectly in the

Resources

tab.

Microsoft Azure Blob Storage Data Objects

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal