Redshift FAQs

Dave Wilks
Dave Wilks
  • Updated

Which datatypes are supported?

All datatypes not specified here are assumed to be string types

Redshift Datatype Syncari Datatype Notes
boolean,bool boolean  
tinyint boolean  
double, real,float, numeric,number,decimal number  
timestamp, timestamp with time zone, timestamp without time zone, timestamp_ltz, timestamp_ntz, timestamp_tz timestamp Timestamps without TZ information are considered to be in the  timezone id set in the Synapse configuration. If not set, it is assumed to be UTC
integer, int, bigint integer  
date date  
datetime datetime  
varchar,char string  

What does Syncari require to access data in tables?

To sync with database tables, Syncari needs to be able to identify each individual record and know if that record was modified since the last sync. To ensure that happens, every database table that you connect to Syncari must include:

  • A primary key that uniquely identifies each record. The primary key must be required for each record.
  • A DATETIME or TIMESTAMP field that identifies when the record was created or updated. Syncari uses the field as a watermark to identify when the record was last updated. This must be populated upon creation and must be populated at the current date and time of modification.
Share this

Was this article helpful?

0 out of 0 found this helpful