Export Data Store Entity to CSV doesn't export all records

Question

I have a view with 11017 records and I'm trying to export this data to csv via Export Data Store Entity to CSV smart service. The issue is that it exports only 11015 records and the file size is around 200KB

Surya Pindiprole · Answer

I used row_number() as the primary key which for some reason generated 173430+ records. So instead I have used 2 ID columns from the table to create a primary key in the view and that solved the problem

Export Data Store Entity to CSV doesn't export all records

Top Replies