Data Check
Data Check
- Go to AWS Management Console

- In the S3 interface
- Select Buckets
- Select asg-datalake-demo-bucket bucket

- We will create a folder for Athena

- In the Create folder interface
- Folder name, enter
Athena
- Select Create folder

- Successfully created folder

- Go to AWS Management Console
- Find Athena
- Select Athena

- In the Athena interface
- Select View settings to set the path to store query results

- In the Amazon Athena interface
- Select Settings
- Select Manage

- Select the path to the newly created Athena folder, then select Choose

- Return to Manage settings interface, check again and select Save

- We use Amazon Athena to query data
- Data Source, select AwsDataCatalog
- Database, select summitdb
- Select raw2022 table
- Select Preview Table

- Make a query of 10 rows of data from the raw2022 table in the database summitdb
- Query successful
- Test data

- Continue checking the data. In the query editor pane, copy and paste the query below
SELECT activity_type,
count(activity_type)
FROM raw2022
GROUP BY activity_type
ORDER BY activity_type
- Select Run Query
- Check the result
