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
- Learn more about Replication in Cloud Data Fusion.