I have a file that calculates adjustments to salesperson goals. Occasionally the adjustments we make are less than a full day (-1) and end up involving more than 2 decimal points.
In this case, I have 1.0669 which needs to stay as 1.0669, but is being converted to 1.07 in workbench. I have tried even uploading this column as a string and converting it to a decimal (tried decimal and decimal fixed-no difference) in the ETL and it always converts to 1.07 - throwing the sales goals off ever so slightly. This matters for what we are doing. What can I do, outside of formatting this in SQL and not the ETL, if anything, to keep the full decimal?