To set permissions for a developer, navigate to the Lake Formation service console.
  1. On the Lake Formation console, click on Data permissions section on the left hand side
  2. Then click on Grant button
  3. On the window that pops up, fill out IAM users and roles as lf-developer, choose tpc for the database and select dl_tpc_web_page and dl_tpc_web_sales as the tables with Select as the only Table permission.

    Note: Please ignore the tables that start with an underscore, those are temp tables.
  4. Leave the Grantable permissions unselected and click on the Grant button.