Table of Contents

Search

  1. Preface
  2. Introduction to Google Cloud Storage V2 Connector
  3. Google Cloud Storage V2 connections
  4. Mappings for Google Cloud Storage
  5. Migrating a mapping
  6. Upgrading to Google Cloud Storage V2 Connector
  7. Appendix A: Data type reference

Google Cloud Storage V2 Connector

Google Cloud Storage V2 Connector

Avro Google Cloud Storage file data types and transformation data types

Avro Google Cloud Storage file data types and transformation data types

Avro Google Cloud Storage file data types map to transformation data types that the Secure Agent uses to move data across platforms.
The following table lists the Avro Google Cloud Storage file data types that the Secure Agent supports and the corresponding transformation data types:
Avro Google Cloud Storage 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
Default precision is 256. You can increase the value up to 104857600 characters.
UNION¹
Corresponding data type in a union of ["primitive_type|complex_type", "null"] or ["null", "primitive_type|complex_type"].
Dependent on primitive or complex data type.
¹Applies only to mappings in advanced mode.
Google Cloud Storage V2 Connector does not support the following Avro complex data types:
  • Enum
  • Fixed

0 COMMENTS

We’d like to hear from you!