Striim 3.10.1 documentation

BigQuery data type support and correspondence

Oracle type

TQL type

BFILE

unsupported

BINARY_DOUBLE

NUMERIC

BINARY_FLOAT

FLOAT64

BLOB

BYTES

CHAR

STRING

CLOB

STRING

An insert or update containing a column of this type generates two CDC log entries: an insert or update in which the value for this column is null, followed by an update including the value.

DATE

DATE

FLOAT

FLOAT64

INTERVALDAYTOSECOND

STRING

INTERVALYEARTOMONTH

STRING

LONG

unsupported

LONG RAW

unsupported

NCHAR

STRING

NCLOB

STRING

NESTED TABLE

unsupported

NUMBER

NUMERIC

NVARCHAR2

STRING

RAW

BYTES

ROWID

unsupported

TIMESTAMP

DATETIME

TIMESTAMP WITHLOCALTIMEZONE

TIMESTAMP

TIMESTAMP WITHTIMEZONE

TIMESTAMP

UROWID

unsupported

VARCHAR2

STRING

VARRAY

unsupported

XMLTYPE

unsupported

PostgreSQL type

BigQuery type

bigint

INT64

bigserial

INT64

bit

unsupported

bit varying

unsupported

boolean

BOOLEAN

box

unsupported

bytea

BYTES

character

STRING

character varying

STRING

cidr

unsupported

circle

unsupported

date

STRING

double precision

FLOAT64

inet

INT64

integer

INT64

int2

INT64

int4

INT64

int4range

STRING

int8

LONG

int8range

STRING

integer

INTEGER

interval

STRING

json

STRING

jsonb

STRING

line

unsupported

lseg

unsupported

macaddr

unsupported

money

unsupported

numeric

NUMERIC

path

unsupported

pg_lan

unsupported

point

unsupported

polygon

unsupported

real

REAL

smallint

INT64

smallserial

INT64

serial

INT64

text

STRING

time

STRING

time with time zone

TIMESTAMP

timestamp

DATETIME

timestamp with time zone

TIMESTAMP

tsquery

unsupported

tsvector

unsupported

txid_snapshot

unsupported

uuid

unsupported

xml

STRING