Amazon Redshift to Google BigQuery mapping
AutoSync maps Amazon Redshift data types to the following Google BigQuery types:
Amazon RedShift type | Google BigQuery type |
---|---|
character |
STRING |
character varying |
STRING |
date |
DATE |
time without timezone |
TIME |
timetz |
TIME |
timestamp without timezone |
TIMESTAMP |
timestamp with timezone |
TIMESTAMP |
boolean |
BOOL |
smallint |
INT64 |
integer |
INT64 |
bigint |
INT64 |
numeric |
NUMERIC |
real |
FLOAT64 |
double precision |
FLOAT64 |
geometry |
STRING |
geography |
STRING |
hllsketch |
JSON |
super |
STRING |
binary varying |
BYTES |
sl_timestamp |
TIMESTAMP |