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
Note
LiveRamp Clean Room doesn’t currently support ArrayType, MapType, or StructType field types. Here are two common approaches we've seen clients use as a substitute for array field types:
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
explodeorsplit.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.
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 |
Parquet Files
Use the table below to understand how LiveRamp Clean Room interprets the field types from Parquet files from AWS, GCP, and Azure.
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 |
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 |