You are here:
Supported Data Types for Custom Templates
The data types supported in custom templates vary based on the clean rooms platform. Adhere to supported data types for successful query execution.
If you’re a provider offering custom templates, follow the specifications for your clean room platform. There are minor differences between AWS and Data 360 that affect the success of your custom template. One notable difference is quoting identifiers.
- In Data 360, to quote an identifier, enclose table names and field names in double quotes (").
- In AWS, to quote an identifier, enclose table names and field names in backticks ( `).
Data types for Data 360 Clean Rooms
For providers using Data 360 clean rooms, see Data 360 Data Types for table configurations and Data 360 SQL Syntax for SQL syntax. Data 360 clean rooms use the Hyper query engine for query execution. Hyper supports these data types for query parameters in custom templates.
| Name | Alias(es) | Description |
|---|---|---|
| boolean | bool | Boolean value with ternary logic (true/false/unknown) |
| numeric | decimal | Exact numeric of selectable precision |
| smallint | int2 | Signed two-byte integer |
| integer | int, int4 | Signed four-byte integer |
| bigint | int8 | Signed eight-byte integer |
| real | float4 | Single-precision floating-point number (4 bytes) |
| double precision | float, float8 | Double-precision floating-point number (8 bytes) |
| character varying | varchar | Variable-length character string with limit |
| character | char | Fixed-length character string |
| date | (None) | Calendar date (year, month, day) |
| time | (None) | Time of day (no time zone) |
| timestamp | (None) | Date and time (no time zone) |
| TIMESTAMP WITH TIME ZONE | timestampTZ | Date and time, including time zone |
| oid | (None) | Object Identifier; a numeric system-assigned unique ID used internally. |
| bytes | bytea, blob, varbinary | Sequence of bytes (octets); used for raw byte data and binary strings. |
Data types for AWS Clean Rooms
If you’re a provider using AWS clean rooms, see AWS data types for table configurations and Overview of SQL in AWS clean rooms for AWS clean room SQL syntax. Here are the supported data types for query parameters in AWS clean rooms.
| Name | Alias | Description |
|---|---|---|
| BIGINT | LONG | Signed eight-byte integer |
| BINARY | Byte sequence values | |
| BOOLEAN | Logical Boolean (true/false) | |
| BYTE | 1-byte signed integer numbers, from -128 to 127 | |
| CHAR | CHARACTER | Fixed-length character string |
| DATE | Calendar date (year, month, day) | |
| DECIMAL | NUMERIC | Exact numeric of selectable precision |
| DOUBLE | Double precision floating-point number | |
| FLOAT | REAL | Single precision floating-point number |
| INTEGER | INT | Signed four-byte integer |
| LONG | 8-byte signed integer numbers | |
| SMALLINT | SHORT | Signed two-byte integer |
| TIMESTAMP | A calendar date and time of day with millisecond precision. | |
| TIMESTAMP_LTZ | Time of day with local time zone | |
| TIMESTAMP_NTZ | Time of day without time zone | |
| TINYINT | BYTE | 1-byte signed integer numbers, from -128 to 127 |
| VARCHAR | STRING | Variable-length character string with a user-defined limit |
