Create schema from external DB Snowflake - Attributes with Decimal values getting truncated in Adobe Campaign Client Console

[NR2]

We created a schema in Adobe Campaign Client Console 8.6.2 from external database (Snowflake). Most attributes got created with correct/equivalent datatype. However for any columns in snowflake with decimals Eg datatype NUMBER(9,2), the data type in Adobe Campaign Client Console was created as  Long by default  (type="long"). We tried to change the tag from type="long" to type="double" or type="float" but got error BASE-010042 value "123.12" is not a valid integer (32 bit). I would like to know if this is a known issue in the product  & if there is any workaround. Your inputs are appreciated !!

[ParthaSarathy · Accepted solution]

Hi @NR2 ,

With same sqlname as in snowflake, create a attribute with datatype type="double"

<attribute label="decimal_field" name="decimal_field" sqlname="idecimal_field" type="double"/>

Disconnect and reconnect the console.

In the UI of Data schema > Data tab, you can only see 2 digits after decimal (Its an expected behavior), but when you do a query or try to print the value in HTML, you can able to see the full decimal value.

Example, If you have 2 records 5.11123 and 5.11126, in Data schema > Data tab both will show the value as 5.11 . But when you do a Query like value greater than 5.11125, the output will be only 5.11126

[NR2]

thank you so much it worked !! I missed the "Disconnect and reconnect the console." step earlier when i tried my self and the UI was showing up that error earlier.