Suggest an Idea

[pankajpatil12]

I have been using Qlik Replicate from last 2-3 years and one of the issue we face is numeric columns are being truncated from postgresql to snowflake. If a field is defined as numeric in postgrsql then when qlik replicates writes that field to snowflake it make the field as number(28,6) , this causes problem of loosing precision of that column. 

I would like to propose a changes where we get option to use wide variety options to define such particular field in the column transformations. We need options like number(35,20) ,number(38,10) ,number(35,15) .

[umeshshaw]

Any solution for this ?

[ashishpandey]

We are also facing same issue and not sure what can we done here. Qlik should update product to take this feature. 

[Gerald_U]

This is as designed.
https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/PostgreSQL/postgresql_data...

Replicate will convert a Numeric datatype to NUMERIC(28,6).

If you want to propose a change to this, please create an Feature request using the link below:
https://community.qlik.com/t5/Suggest-an-Idea/idb-p/qlik-ideas

Gerald

[pankajpatil12]

@Gerald_U I have proposed to make this field configurable in the original post. What feature request you are asking us to create now? 

[Gerald_U]

@pankajpatil12 

Hello, 

You need to create the proposal using the link below:

https://community.qlik.com/t5/Suggest-an-Idea/idb-p/qlik-ideas

The link above is the platform to request changes to the application.

Thank you,

Gerald 

[john_wang]

Hello @pankajpatil12 , @umeshshaw , @ashishpandey ,

This default behavior can be changed in PostgreSQL and Replicate, the precision/scale can be kept as your wish. I summarized the steps in article Replicate - How to keep NUMERIC field precision and scale for PostgreSQL source endpoint

Let me know if it works.

Regards,

John.

[Meghann_MacDonald]

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.