Create schema from external DB Snowflake - Attributes with Decimal values getting truncated in Adobe Campaign Client Console | Adobe Higher Education
Skip to main content
N
NR2
November 21, 2024
解決済み

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

  • November 21, 2024
  • 2 の返信
  • 685 ビュー

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

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

2 の返信

ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor回答
Community Advisor
November 21, 2024

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

 ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
N
NR2作成者
November 21, 2024

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. 

契約条件Accessibility statement

Loading footer...