Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Allow S3 to create column with decimal type instead of double

Answered
Matt Jucius User

Currently, when ingesting a file from S3 that has decimal numbers in a column, such as a column containing currency values, the table created in the destination database (Redshift in our case) is created with a type Double.  We would like a way to have FiveTran to create this column as a DECIMAL type.

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Alison Fivetranner

    Hi Matt,

    Thank you for reaching out to us with this request. I'd like to understand a little more about your use case and if the DECIMAL type would be preferable for all columns of all S3 files that have decimal numbers?

    We try very hard to do the right thing and avoid the need for tiresome configuration on every file, however that means we can't easily differentiate when a decimal is representing currency or not, I think the DOUBLE is more efficient in Redshift so is the one we use.

    Best regards

    Alison