Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r092

...

      
Source Data TypeSupported?
D s item
Data Type
Data Type
Notes
arrayYArray 
bigintYInteger
Info

NOTE: The

D s platform
may infer bigint columns containing very large or very small values as String data type.

binaryYString
booleanYBool 
charYString 
dateYDatetime 
decimalYDecimal 
doubleYDecimal 
floatYDecimal
Info

NOTE: On import, some float columns may be interpreted as Integer data type in the

D s platform
. To fix, you can explicitly set the column's data type to Decimal in the Transformer page.

intYInteger
mapYObject
smallintYInteger 
stringYString 
structYObject 
timestampYDatetime
tinyintYInteger
uniontypeN 

varcharYString 

Write/Publish

Create new table

...

D s item
itemData Type
Databricks Tables Data TypeNotes
Stringstring 
Integerbigint
Info

NOTE: The

D s platform
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.

Decimaldouble 
Boolboolean 
DatetimeTimestamp/string (see Notes on Datetime columns below)Target data type is based on the underlying data. Time zone information is retained.
Objectstring 
Arraystring 

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

D s item
itemcolumns
of Map and Array type, even if you imported data from this source.

...

       

StringIntegerDatetimeBoolDecimalMapArrayOut of Range error
CHARYYYYYYY 
VARCHARYYYYYYY 
STRINGYYYYYYY 
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

...