Other: Missing rows in destination table(snowflake)

We have a duplicate data in NetSuite table called amortizationschedulerecurrence and we are missing those duplicate rows when we pull into the snowflake.

For Example:
In the source system NetSuite for AMORTIZATIONSCHEDULE id '22193' , we have 13 rows but in snowflake showing 12 rows. one identical row is missing (It's not actually a duplicate according to business).

I think we just need to add fivetran Index column to retrieve identical rows.

To enhance clarity, I've included a sample query and example. In one table, we encountered duplicate row from source system, which was successfully identified and captured by Fivetran through the addition of fivetran index column. However, the duplicate row not captured in another table because there is no Index column.

e.g:
We have duplicate row in “REVRECSCHEDULERECURRENCE” and it was handled by fiveTran by adding a column called FIVETRAN_INDEX.

Sample Query:

select * from raw.netsuite.revrecschedulerecurrence where revrecschedule = 25982 and _fivetran_deleted = false;

But in the “AMORTIZATIONSCHEDULERECURRENCE” table we miss a row. Due to missing FIVETRAN_INDEX.

Sample Query:

select * from raw.netsuite.amortizationschedulerecurrence

where amortizationschedule = 22193 and _fivetran_deleted = false;

So, if FIVETRAN_INDEX column can be added in the “AMORTIZATIONSCHEDULERECURRENCE” table then the issue will be resolved.

Could you please solve this issue ASAP?