idea Re: Add precision and scale for Postgresql source endpoint for numeric fields in Suggest an Idea

Add precision and scale for Postgresql source endpoint for numeric fields

pankajpatil12 — Fri, 29 Apr 2022 17:08:02 GMT

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) .

Re: Add precision and scale for Postgresql source endpoint for numeric fields

umeshshaw — Thu, 26 May 2022 18:58:16 GMT

Any solution for this ?

Re: Add precision and scale for Postgresql source endpoint for numeric fields

ashishpandey — Thu, 26 May 2022 18:58:36 GMT

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

Re: Add precision and scale for Postgresql source endpoint for numeric fields

Gerald_U — Fri, 27 May 2022 20:28:58 GMT

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

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

Re: Add precision and scale for Postgresql source endpoint for numeric fields

pankajpatil12 — Tue, 31 May 2022 14:42:34 GMT

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

Re: Add precision and scale for Postgresql source endpoint for numeric fields

Gerald_U — Mon, 06 Jun 2022 04:14:49 GMT

@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

Re: Add precision and scale for Postgresql source endpoint for numeric fields

john_wang — Mon, 13 Feb 2023 14:58:19 GMT

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.

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

Meghann_MacDonald — Wed, 02 Aug 2023 14:58:19 GMT

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.

Re: Add precision and scale for Postgresql source endpoint for numeric fields - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 14:58:21 GMT