Skip to main content

Field Types for Data Connections

LiveRamp Clean Room translates field types across cloud platforms into a common harmonized schema. Since each cloud platform uses slightly different names and interpretations for field types, below are tables for you to use to understand how LiveRamp Clean Room interprets the field types from your cloud, based on source and file schema.

This common schema enables cloud interoperability as you partner with others.

Field Types Supported in LiveRamp Clean Room

LiveRamp Clean Room natively supports the following field types:

  • STRING

  • INTEGER

  • LONG

  • DOUBLE

  • DECIMAL

  • DATE

  • BOOLEAN

  • TIMESTAMP

  • ARRAY

Note

LiveRamp Clean Room does not currently support MapType or StructType field types, or ArrayType for connections other than AWS, GCS, and Iceberg. Here are two common approaches we've seen clients use as a substitute for these field types, if needed:

  • Bring the segment/attribute data field in as a STRING field type with comma-separated values. Once the data is in LiveRamp Clean Room, you can flatten the data within your SQL queries using functions like explode or split.

  • Denormalize the data using your customID as the key, which results in multiple rows for each customID, one for each segment.

Field Types for CSV Files

Use the table below to understand how LiveRamp Clean Room interprets the field types from CSV files from AWS, GCP, and Azure.

Note

The ARRAY field type is only supported in CSV files from AWS and GCP.

CSV Field Type (from AWS, GCP, and Azure)

LiveRamp Clean Room Data In Field Mapper

INTEGER

INTEGER

LONG

LONG

DOUBLE

DOUBLE

DECIMAL

DECIMAL

DATE

DATE

BOOLEAN

BOOLEAN

TIMESTAMP

TIMESTAMP

STRING

STRING

ARRAY

ARRAY

Parquet Files

Use the table below to understand how LiveRamp Clean Room interprets the field types from Parquet files from AWS, GCP, and Azure.

Note

The ARRAY field type is only supported in Parquet files from AWS and GCP.

Parquet Field Type (from AWS, GCP, and Azure)

LiveRamp Clean Room Data In Field Mapper

STRING

STRING

DATE

DATE

BOOLEAN

BOOLEAN

INT, INT8, INT16, INT32, INTEGER, INTEGER(8,true), INTEGER(8,false), INTEGER(16,true), INTEGER(16,false), INTEGER(32,true), INTEGER(32,false)

INTEGER

INT64, INTEGER(64,true), INTEGER(64,false)

LONG

FLOAT, DOUBLE

DOUBLE

TIMESTAMP, TIMESTAMP(MILLIS,true), TIMESTAMP(MICROS,true), TIMESTAMP(MICROS,false), TIME(MILLIS,true), TIME(MICROS,true), INT96

TIMESTAMP

DECIMAL

DECIMAL

ARRAY

ARRAY

Snowflake Tables

Use the table below to understand how LiveRamp Clean Room interprets the field types from Snowflake tables.

Snowflake Table Field Type

LiveRamp Clean Room Data In Field Mapper

FLOAT

DECIMAL

DATE

DATE

BOOLEAN

BOOLEAN

For NUMBER(precisionInt,scaleInt), see below:

scaleInt > 0

DECIMAL

precisionInt > 0 and precisionInt <= 19

INTEGER

precisionInt > 19

LONG

VARCHAR

STRING

TIMESTAMP_NTZ, TIMESTAMP_LTZ, TIMESTAMP_TZ

TIMESTAMP

Salesforce

Use the table below to understand how LiveRamp Clean Room interprets the data types from Salesforce (object-based data, such as from Sales Cloud).

Salesforce Data Type

LiveRamp Clean Room Data In Field Mapper

double, currency

DOUBLE

boolean

BOOLEAN

datetime, time

TIMESTAMP

date

DATE

string, textarea, phone, email, id, percent, anyType, calculated, reference, masterrecord, encryptedstring, url

STRING

int, byte

INTEGER

long

LONG

Glue Catalog

Use the table below to understand how LiveRamp Clean Room interprets the data types from Glue Catalog.

Glue Catalog Data Type

LiveRamp Clean Room Data In Field Mapper

STRING, VARCHAR

STRING

TINYINT, SMALLINT, INT

INTEGER

BIGINT

LONG

FLOAT, DOUBLE

DOUBLE

DECIMAL

DECIMAL

BOOLEAN

BOOLEAN

DATE

DATE

TIMESTAMP

TIMESTAMP

ARRAY

ARRAY