Datatype

Source: https://knowledge.domo.com/Prepare/Magic_Transforms/DataFusion/01Combining_DataSets_Using_DataFusion

 

• LONG stores numbers as numeric values, including decimal, fractional, and whole numbers.
• DOUBLE stores double-precision floating point number values.
• STRING stores alphanumeric characters as text.
• DATETIME stores year, month, day, hour, minute, and second values.
• DATE stores year, month, and day values.
• TIME stores hour, minute, and second values.

Source: https://dojo.domo.com/t5/Workbench/What-the-difference-between-double-and-long-data-types/m-p/15890/highlight/true#M375

• DOUBLE stores decimal values with a higher precision (24-53 digits) than a FLOAT type. LONG is used when a wider range than INT is needed.

What I'm not sure is why the SDK's don't have the same data types listed because you're right, it has DECIMAL as an option. Try running a test, if you store it as a DECIMAL does it come out the same as a DOUBLE?

I'm pretty sure Magic ETL doesn't have TIME as a data type, though it may have been a recent enhancement. I'd be surprised if it were in Fusion if it's not in ETL, but perhaps...forgive my not checking, but I'm Dojoing on my phone.

On the number formats...I think we are all confused. Lol. I think I typically use Decimal or Whole Number, depending on the type of info, and leave the rest of the types. I'm pretty sure it makes it 2 decimal places. This reduces the amount of tinkering you have to do in the visualizations. Of course the argument can be made for enabling users to go out more decimal places, but for currency, you seldom require that.