Search code examples
aws-glue-data-catalog

AWS Glue View like Hive View


In Hive we all know we can define a non-materialized View. Easy.

My question is that if a similar construct can be created in AWS Glue Catalog? I see materialized view, but that it not what I mean.

I think it is not possible, but I may be missing something. Thanks in advance.


Solution

  • You can use Athena for this. Athena is a serverless SQL Query engine (Presto) that can query your Data Catalog.

    Athena provides a view feature, where you can create non materialized views from your Glue Meta Data Catalog tables.