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

JSON Data Types and Transformation Data Types

JSON Data Types and Transformation Data Types

JSON data types map to transformation data types that the Data Integration Service uses to move data across platforms.
The following table compares the JSON data types that the Data Integration Service supports and the corresponding transformation data types:
JSON
Transformation
Range
Array
Array
Unlimited number of characters.
Double
Double
Precision of 15 digits.
Integer
Integer
-2,147,483,648 to 2,147,483,647.
Precision of 10, scale of 0.
Object
Struct
Unlimited number of characters.
String
String
1 to 104,857,600 characters.
You can use JSON data types to read and write complex file objects in mappings that run on the Spark engine only.

Unsupported JSON Data Types

The Developer tool does not support the following JSON data types:
  • Date
  • Decimal
  • Timestamp
  • Enum
  • Union