2

I have created a view in Athena and see it in my Glue Data Catalog. I would like to access the view via Redshift Spectrum/Glue Catalog Sharing.

Per the AWS documentation:

If you have created Athena views in the Data Catalog, then Data Catalog treats views as tables

Source: https://docs.aws.amazon.com/athena/latest/ug/views.html

Is it possible to query Athena views via Redshift Spectrum?

Melissa Guo
  • 948
  • 9
  • 32
  • Unfortunately seems not possible right now. Why do you not create a view in Redshift Spectrum instead? – Hyruma92 Apr 01 '21 at 09:32
  • With this option, the view would need to be maintained by each team we share our Glue Data Catalog with. – Melissa Guo Apr 01 '21 at 20:45
  • 1
    still not possible as of 03/17/2023...and in our case, we are unable to create regular views on Spectrum tables because we use views to achieve access mgmt (user group A can only see view A, user group B can only see view B, but both view A and view B need to query the same Spectrum table). eventually we got around it by creating materialized views – Zach Mar 17 '23 at 13:46

0 Answers0