DZone Database Zone
9 Things to Consider When Considering Amazon Athena
Amazon has generated a lot of excitement around their release of Athena, an ANSI-standard query tool that works with data stored in Amazon S3. Athena and S3 can deliver results quickly and with the power of sophisticated data warehousing systems. This article covers nine things that you should know about Athena when considering it as a query service.
1. Schema and Table DefinitionsTo be able to query data with Athena, you will need to make sure you have data residing on S3. With data on S3, you will need to create a database and tables. When creating schemas for data on S3, the positional order is important. For example, if you have a source file with ID, DATE, CAMPAIGNID, RESPONSE, ROI, and OFFERID columns, then your schema should reflect that structure.
No comments:
Post a Comment