...
| Source Data Type | Supported? | | Notes |
|---|
| array | Y | Array | |
|
| bigint | Y | Integer |
| Info |
|---|
NOTE: The may infer bigint columns containing very large or very small values as String data type. |
|
| binary | Y | String | |
|
| boolean | Y | Bool | |
|
| char | Y | String | |
|
| date | Y | Datetime | |
|
| decimal | Y | Decimal | |
|
| double | Y | Decimal | |
|
| float | Y | Decimal |
| Info |
|---|
NOTE: On import, some float columns may be interpreted as Integer data type in the . To fix, you can explicitly set the column's data type to Decimal in the Transformer page. |
|
| int | Y | Integer | |
|
| map | Y | Object | |
|
| smallint | Y | Integer | |
|
| string | Y | String | |
|
| struct | Y | Object | |
|
| timestamp | Y | Datetime | |
|
| tinyint | Y | Integer | |
|
| uniontype | N | | |
|
|
| varchar | Y | String | |
|
Write/Publish
Create new table
...
| Databricks Tables Data Type | Notes |
|---|
| String | string |
|
| Integer | bigint |
| Info |
|---|
NOTE: The may infer Integer columns containing very large or very small values as String data type. Before you publish, you should verify that your columns containing extreme values are interpreted as Integer type. You can import a target schema to assist in lining up your columns with the expected target. For more information, see Overview of RapidTarget. |
|
| Decimal | double |
|
| Bool | boolean | |
|
| Datetime | Timestamp/string (see Notes on Datetime columns below) | Target data type is based on the underlying data. Time zone information is retained. |
| Object | string | |
|
| Array | string | |
|
Append to existing table
If you are publishing to a pre-existing table, the following data type conversions apply:
...
| Info |
|---|
NOTE: You cannot append to Databricks Tables map and array column types from of Map and Array type, even if you imported data from this source. |
...
| String | Integer | Datetime | Bool | Decimal | Map | Array | Out of Range error |
|---|
| CHAR | Y | Y | Y | Y | Y | Y | Y | |
|
| VARCHAR | Y | Y | Y | Y | Y | Y | Y | |
|
| STRING | Y | Y | Y | Y | Y | Y | Y | |
|
| INT | |
| Y | | | | | |
|
|
|
|
| NULL |
| BIGINT | |
| Y | | | | | |
|
|
|
|
| n/a |
| TINYINT | | | | | | | |
|
|
|
|
|
|
| NULL |
| SMALLINT | | | | | | | |
|
|
|
|
|
|
| NULL |
| DECIMAL | |
| Y | | |
|
| Y | | |
|
| NULL |
| DOUBLE |
| Y | | |
|
| Y | | |
|
| n/a |
| FLOAT | | | | |
|
|
|
| Y | | |
|
| NULL |
| TIMESTAMP | |
|
| Y | | | | | |
|
|
|
|
|
| BOOLEAN | | | |
|
|
| Y | | | | |
|
|
|
|
Notes on Datetime columns
...
