Postgres Composite Column Support
PlannedFivetran should support composite data type columns from postgres.
-
Hi Matt,
We have this feature on the roadmap, but without a specific timeline at this point. Let us evaluate it deeper and see if it's possible to prioritize.
In the meantime, can you please share examples of composite types that you use?
Thanks,
Val Kulichenko, Fivetran Product Team -
Sure, here you go. Let me know if you need any other info!
I would be happy if the data even landed as simple json or string values. I can parse the data as needed once it's landed in my destination.
-
total_market_value—money_value(amount numeric(78,0)+currency_code currency_code) -
report_net—money_value(amount numeric(78,0)+currency_code currency_code) -
dollar_amount—money_value(amount numeric(78,0)+currency_code currency_code) -
outstanding_principal—money_value(amount numeric(78,0)+currency_code currency_code) -
custom_rate_bps—rate_value(basis_points numeric(20,4))
-
Please sign in to leave a comment.
Comments
2 comments