Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an MSSQL DB with a lot of floats, and am replicating to S3.
With replicate, that means that the number 153 gets written to csv as +1.5300000000000000e+02
The docs explain the mapping as float > Real8 > Real8(14).
I'm sure that is useful to someone, but it sure isn't me !
Ok, so what to do about it ?
Yes, I could manually set a different datatype in 'transformations', but I have 766 such fields across 430+ tables.
.. and I have 2 databases like this.
Can anyone suggest an easier way than blistering my fingers doing it manually ?
Thanks
Hi @simonB2020 ,
You can set it to a different datatype using Global transformation for all the tables once.
Thanks,
Swathi
Hey @simonB2020 ,
It's possible to update the query syntax for AmazonS3Syntax in your configuration. Thus you can avoid manual work of setting up the transformations on each table.
This requires editing an important configuration file, so I would open a Support ticket for further assistance.
**Edit 1- Please defer to Swathi's solution. Much more straight forward and safer option. Global Rules -> Transformation -> Convert Data Type then select what you would like to convert to
Best,
Kelly
Hi @simonB2020 ,
You can set it to a different datatype using Global transformation for all the tables once.
Thanks,
Swathi
Thanks for the solution, works a treat 🙂