How to deal with a big amount of rows in a .csv

Guys, I need your help with something I don't know how to handle. I have 5000 data rows in a CSV file with different values (columns=10). One of the columns is for Amount (USD).

I can import all into a document table in SupaBase, but when I ask how many rows are in amounts greater than 50k, I get only 7, while the CSV has 1670. How can I handle a vast amount of data?

This is initially a test, but I plan to create an AI agent that reads big .csv files to query the data inside.

I appreciate any help you can provide.

2 comments