[Back to main guide](../README.md) | [Next](appendixA.md)

___

## 10. Catalog de-duplicated data and query using Amazon Athena

Your dedup’ed data is now available under transformresult folder in S3 bucket.

Follow the similar steps as in **Activity#5, 6 and 7** to

a) **Crawl and Catalog** data in AWS Glue

b) Login as Data Lake Administrator and **assign** the dlanalyst **permission** to **Select** the data

c) Query the data using **Amazon Athena**

NOTE: Data generated from ETL Job consists of quotes and you would need to edit the table properties. We have provided the screenshots for the above steps including how to remove quotes in the result-set in the [Appendix B](appendixB.md) below.

You can query data using Amazon Athena and export the results to see the deduplicated results.

___

[Back to main guide](../README.md) | [Next](appendixA.md)