I enabled audit as you suggested and found the actual problem. It was because of a missing license. I got one and problem solved.

It was confusing that I could see table properties without the license but failed when querying the data.