Hi,
I found two different information about the data type we can use for the schema:
1) One is coming from https://developer.domo.com/docs/dataset-api-reference/dataset#Create%20a%20DataSet and says we have these types: STRING, DECIMAL, LONG, DOUBLE, DATE, and DATETIME
2) The other one is coming from https://knowledge.domo.com/Prepare/Magic_Transforms/DataFusion/01Combining_DataSets_Using_DataFusion and says we have these types: LONG, DOUBLE, STRING, DATETIME, DATE and TIME
The common types are: STRING, LONG, DOUBLE and DATETIME
The differences are: DECIMAL and TIME
Which one is the correct set of types?
Also what is the difference between DECIMAL and DOUBLE and LONG?
In what I read:
- DOUBLE: it's for floating numbers
- LONG: it should be used for integers
- DECIMAL: the same as DOUBLE?
If I have a column that stores currency numbers, should I use DOUBLE or DECIMAL?
Thanks