Hi,
I am looking for advice on how to read the rows that are skipped during SPICE import. On downloading the errors row file, I see that the ERROR_TYPE is ‘NUMBER_BITWIDTH_TOO_LARGE’. To fix the issue, I have converted the numeric column to string in Custom SQL but see that the rows are still skipped.
Could you please provide any suggestions on solving this issue. Thanks!
Hi @Reena I understand you have converted the numeric column to string in Custom SQL, but could you please go into the QuickSight dataset and check the column type of the particular column in question. I suspect it might still be numeric, and if that’s the case, please change that to string and then reimport the data, which should work. Let us know if this solves your issue, thanks!