Oracle Data Types	Destination Data Type
NUMBER(n,0) where n<=9	int
NUMBER(n,0) where n>9	bigint
NUMBER(n,m) where m!=0, BINARY_DOUBLE, FLOAT	double
BINARY_FLOAT	float
DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIMEZONE	timestamptz
VARCHAR2, NVARCHAR2, CLOB, NCLOB, LONG, RAW, LONG RAW, BLOB, BFILE, INTERVAL DAY TO SECOND, INTERVAL YEAR TO MONTH, CHAR(* BYTE)	string

timestamptz timezone

OLake always ingests timestamp data in UTC format, independent of the source timezone.