ERROR: relation "public.foo_bar" does not exist

Hello,

when I try to view certain tables in my postgres database, I get an error in DataGrip (and the postgresql log):

    postgres_1  | 2018-05-25 09:20:55.985 UTC [373] ERROR:  relation "public.foo_bar" does not exist at character 17
    postgres_1  | 2018-05-25 09:20:55.985 UTC [373] STATEMENT:  SELECT t.* FROM public.foo_bar t LIMIT 501

I know the table exists and is in the 'public' schema; other tables work, and I haven't been able to find out why some do and some don't.

Interestingly though, when I copy and paste the SELECT statement in the DataGrip console, it executes and returns as normal.

What could be the issue?