Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Microsoft Azure Blob Storage
  3. PowerExchange for Microsoft Azure Blob Storage Configuration
  4. Microsoft Azure Blob Storage Connections
  5. Microsoft Azure Blob Storage Data Objects
  6. Microsoft Azure Blob Storage Mappings
  7. Data Type Reference

PowerExchange for Microsoft Azure Blob Storage User Guide

PowerExchange for Microsoft Azure Blob Storage User Guide

Avro File Data Types and Transformation Data Types

Avro File Data Types and Transformation Data Types

Avro file data types map to transformation data types that the Data Integration Service uses to move data across platforms.
The following table lists the Avro file data types that the Data Integration Service supports and the corresponding transformation data types:
Avro File Data Type
Transformation Data Type
Range and Description
Array
Array
Unlimited number of characters
Boolean
Integer
TRUE (1) or FALSE (0)
Bytes
Binary
Precision 4000
Double
Double
Precision 15
Float
Double
Precision 15
Int
Integer
-2,147,483,648 to 2,147,483,647 Precision 10, scale 0
Long
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
Map
Map
Unlimited number of characters
Null
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
Record
Struct
Unlimited number of characters
String
String
1 to 104,857,600 characters
The Null data type is supported only in the native environment.

Avro Union Data Type

A union indicates that a field might have more than one data type. For example, a union might indicate that a field can be a string or a null. A union is represented as a JSON array containing the data types.
The Developer tool only interprets a union of ["primitive_type|complex_type", "null"] or ["null", "primitive_type|complex_type"]. The Avro data type converts to the corresponding transformation data type. The Developer tool ignores the null.

Unsupported Avro Data Types

The Developer tool does not support the following Avro data types:
  • enum
  • null