Prerequisites
Before you start this tutorial, you must have an Amazon Web Services account that you can sign in as a user with the correct permissions. For more information, see Sign up for an Amazon Web Services account and .
The tutorial assumes that you are familiar with IAM roles and policies. For information about IAM, see the IAM User Guide
You need to set up the following Amazon resources to complete this tutorial:
Data lake administrator user
Lake Formation data lake settings
Amazon Athena engine version 3
To create a data lake administrator
-
Sign in to the Lake Formation console at https://console.amazonaws.cn/lakeformation/
as an administrator user. You will create resources in the US East (N. Virginia) Region for this tutorial. -
On the Lake Formation console, in the navigation pane, under Permissions, choose Administrative roles and tasks.
-
Select Choose Administrators under Data lake administrators.
-
In the pop-up window, Manage data lake administrators, under IAM users and roles, choose IAM admin user.
-
Choose Save.
To enable data lake settings
-
Open the Lake Formation console at https://console.amazonaws.cn/lakeformation/
. In the navigation pane, under Data catalog, choose Settings. Uncheck the following: Use only IAM access control for new databases.
-
Use only IAM access control for new tables in new databases.
-
Under Cross account version settings, choose Version 3 as the cross account version.
-
Choose Save.
To upgrade Amazon Athena engine to version 3
-
Open Athena console at https://console.amazonaws.cn/athena/
. -
Select the Workgroup and select primary workgroup.
-
Ensure that the workgroup is at a minimum version of 3. If it is not, edit the workgroup, choose Manual for Upgrade query engine, and select version 3.
Choose Save changes.