Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
sschuetz
Frequent Visitor

Postgres CDC numeric as Bigdecimal binary

Hi 

 

When using Postgres CDC in the realtimehub, all numeric values are loaded as bigdecimal binary.

these are hard to convert.

debezium supports a setting to change this, can this be done somehow with fabric?

2 REPLIES 2
v-tangjie-msft
Community Support
Community Support

Hi @sschuetz ,

 

As a workaround, consider implementing a data transformation step within your data pipeline. This can be done by using Azure Data Factory or a similar service to transform values into a more desirable format before or after the CDC process.

For more details, please refer:  Ingest data into your Warehouse using data pipelines - Microsoft Fabric | Microsoft Learn

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Hi Neeko

 

We wanted to use the values in streaming, is there a way we can use python in a stream transformation?

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!

Top Solution Authors
Top Kudoed Authors