I have access to our tables, but I can't run queries on them

I get the message “permission denied for relation pardotvisitoractivity”. What’s going on?

By default, only the owner of the schema a user creates by running create schema foo can read from schema foo. The owner needs to explicitly grant privileges to other users so they can read from this schema.

This commonly occurs when users are trying to set up looker connections and are creating the looker_scratch schema.