Replication data types

This page lists the data type conversions from supported source databases to the BigQuery destination when using Cloud Data Fusion Replication.

Data type mappings in Replication

MySQL

The following table lists data type conversions from the MySQL source database to the BigQuery destination.

MySQL data type BigQuery data type
BIGINT INT64
BINARY BYTES
BIT BOOL
BLOB BYTES
CHAR STRING
DATE DATE
DATETIME DATETIME
DECIMAL NUMERIC
DOUBLE FLOAT64
ENUM OF CHARS STRING
FLOAT FLOAT64
INT INT64
JSON STRING
LONGBLOB BYTES
LONGTEXT STRING
MEDIUMBLOB BYTES
MEDIUMINT INT64
MEDIUMTEXT STRING
SET STRING
SMALLINT INT64
TEXT STRING
TIME TIME
TIMESTAMP TIMESTAMP
TINYBLOB BYTES
TINYINT INT64
TINYTEXT STRING
VARBINARY BYTES
VARCHAR STRING
YEAR INT64
Complex data types Supported in BigQuery
ENUM Supported
SET Supported

Oracle

The following table lists data type conversions from the Oracle source database to the BigQuery destination.

Oracle data type BigQuery data type
BFILE STRING
BINARY_DOUBLE Unsupported
BINARY_FLOAT Unsupported
BLOB Unsupported
CHAR STRING
CLOB Unsupported
DATE TIMESTAMP
DECIMAL STRING
DECIMAL(p) INT64
DECIMAL(*) STRING
DECIMAL(*,s) Unsupported
DECIMAL(p,s) INT64
DOUBLE PRECISION FLOAT64
FLOAT FLOAT64
INTEGER STRING
INTERVAL DAY TO SECOND Unsupported
INTERVAL YEAR TO MONTH Unsupported
LONG Unsupported
LONG RAW Unsupported
NCHAR STRING
NCLOB Unsupported
NUMBER STRING
NUMBER(p) INT64
NUMBER(*) STRING
NUMBER(*,s) Unsupported
NUMBER(p,s) INT64
NVARCHAR2 STRING
RAW BYTES
REAL FLOAT64
ROWID STRING
SDO_GEOMETRY Unsupported
SMALLINT STRING
TIMESTAMP TIMESTAMP
TIMESTAMP WITH TIME ZONE Unsupported
VARCHAR STRING
VARCHAR2 STRING

SQL Server

The following table lists data type conversions from the Microsoft SQL Server source database to the BigQuery destination.

SQL Server data type BigQuery data type
BIGINT INT64
BINARY BYTES
BIT BOOL
CHAR STRING
DATE DATE
DATETIME DATETIME
DATETIME2 DATETIME
DATETIMEOFFSET Unsupported
DECIMAL NUMERIC
FLOAT FLOAT64
GEOGRAPHY Unsupported
GEOMETRY Unsupported
HIERARCHYID BYTES
IMAGE BYTES
INT INT64
MONEY NUMERIC
NCHAR STRING
NTEXT STRING
NUMERIC NUMERIC
NVARCHAR STRING
REAL FLOAT64
SMALLINT INT64
SMALLMONEY NUMERIC
TEXT STRING
TIME TIME
TINYINT INT64
UNIQUEIDENTIFIER STRING
VARBINARY BYTES
VARCHAR STRING
XML STRING

What's next