2

Is it possible to create views in Amazon Athena?

Since an External table is essentially metadata for data stored in files on S3, there's no transformation involved. Therefore, you can't handle data inconsistencies. Quite often, this can result in tables being defined with lots of string fields.

Can you create a view over the top of the External table that can contain the transformation logic, allowing users to query a "cleansed" view of the data?

GShenanigan
  • 5,409
  • 5
  • 38
  • 48

2 Answers2

11

Looks like they have added this support now AWS Doc

Radford7821
  • 335
  • 3
  • 11
3

While that is a nice feature that you are looking for,

AWS Athena does not support creating any view.

Reference Documentation of supported DDL's:

http://docs.aws.amazon.com/athena/latest/ug/language-reference.html

Hope it helps.

Kannaiyan
  • 12,554
  • 3
  • 44
  • 83