partitioned table record count wont match with actual table

[mazizmacf]

Started getting issue in datalake where no of records in lake database vs partitioned table wont match
It was working fine from last 6 months

Any idea where to check and how to get it resolved?

select count(id) from [dbo].[account] 
84K records
select count(id) from[dbo].[account_partitioned] 
4K records

@Anonymous

[Anonymous]

Hi @mazizmacf ,

To investigate the issue, you can start by checking the following:

1. Data loading process: Ensure that the data loading process for both tables is working correctly and that no records are being skipped or filtered out during the process.

2. Partitioning logic: Review the partitioning logic to make sure it's correctly implemented and that all records are being assigned to the appropriate partitions.

3. Data consistency: Check for any data inconsistencies or corruption that might have occurred in either table.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.