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
orsplit
.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 |