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