Response in seconds if you hit partitions (a version of index that only support equality and its implemented in folders in this case) and your storage system contains content metadata like parquet or orc.

Is not a BI tool tho, if queries have high variability on the where clause and you can't leverage indexes then you're looking at minutes as response time.

If the data is not in structures but plain csv/json, all bets are off.

I've not yet tested it at terabyte scale albeit it should happily scale up there.