Login to your AWS account as the user lf-campaign-manager. Proceed to the Athena console.
  1. From the AWS Management console, search for Amazon Athena service
  2. Make sure you are logged in as a lf-campaign-manager user
  3. Locate and expand the table section on the left hand side of the screen. Notice that a campaign manager has access to all tables except dl_tpc_web_page
  4. On the top left hand side of the screen, select Saved Queries and choose a query named LF-CampaignManager-Query
  5. Run each query one at a time, highlight(select) each of the entire statement on the Athena console and then click on the Run query button. You will notice the results appear within few seconds:
  6. As expected, the second query throws an error as table dl_tpc_web_page is not accessible to a campaign manager