I am running a query and I get an error that the “table or view does not exist”. How do I get past this?

  • Confirm you have correctly typed the name of the table or view.
  • Confirm you have access to that table or view. You can do this by checking which views are available in the roles you have been granted. If the view is in a role you do not currently have, you can request access to the role that it goes with.
  • Refer to the section ‘ODS Data Dictionary Documentation’ to see the various reporting roles and views.