Step 11: Query the Data Lake Using Amazon Athena - AWS Lake Formation

Step 11: Query the Data Lake Using Amazon Athena

Use the Amazon Athena console to query the AWS CloudTrail data in your data lake.

  1. Open the Athena console at https://console.aws.amazon.com/athena/, and sign in as the data analyst, user datalake_user.

  2. If necessary, choose Get Started to continue to the Athena query editor.

  3. For Data source, choose awsdatacatalog.

  4. For Database, choose lakeformation_tutorial.

    The Tables list populates.

  5. In the pop-up menu beside one of the tables, choose Preview table.

    The query runs and displays 10 rows of data.