Skip to main content
Question

Issue reading Numerics & Decimals from Red Shift

  • June 25, 2018
  • 4 replies
  • 13 views
E

Has anyone has success reading in either numeric or decimal data types from Red Shift?

I am using 2018.0, and after successfully connecting to the Red Shift database, I cannot see any fields that have a numeric or decimal data type.

I can see double precision and float types successfully.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

brianatsafe
Safer
Forum|alt.badge.img+13
  • brianatsafeSafer
  • Safer
  • 92 replies
  • June 25, 2018

Hi @elhastino1, sounds like we need to test this in house. I suspect that there may be a problem with the format. We will update this thread with what we find. I really appreciate you bringing this information to our attention!

rahulsharma
Safer
Forum|alt.badge.img+10
  • rahulsharmaSafer
  • Safer
  • 359 replies
  • July 3, 2018

Hi @elhastino1, we have reproduced the problem. I have filed a PR with Dev Team and they are currently looking into it. I will notify you once the support is added.

E
  • elhastino1
  • Author
  • 2 replies
  • July 4, 2018

Thanks team,

I have no particular urgency on this as the Red Shift team have been able to change data types for me without any issues.

rahulsharma
Safer
Forum|alt.badge.img+10
  • rahulsharmaSafer
  • Safer
  • 359 replies
  • July 6, 2018

@elhastino1, I have great news our Dev Team has added support for Numeric data types to Amazon RedShift to FME 2018.1.

 

We have also added support for timestampz data type with 2019.0 beta

Community Stats

32,085
Posts
121,845
Replies
39,726
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.