I have a pipeline in Azure data factory which executes a script in snowflake which looks like this:
INSERT OVERWRITE <TABLE> SELECT * FROM <TABLE> ORDER BY <COL1>;
The table used in select and insert is same.
When execution happens after few minutes I am getting below error in ADF:
arithmetic operation resulted in an overflow
I don t have any identity column in this table and not doing any other operation other than the above query. Can someone please help me in understanding what is causing this error and solution?
I tried checking the documentation and some google but no luck around this.