Data Catalog views considerations and limitations - Amazon Lake Formation
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Data Catalog views considerations and limitations

In Amazon Glue Data Catalog, a view is a virtual table in which the contents are defined by a query that references one or more tables. You can create a view that references up to 10 tables using SQL editors for Amazon Athena or Amazon Redshift. Underlying reference tables for a view can belong to the same database or different databases within the same Amazon Web Services account.

The following considerations and limitations apply to Data Catalog views.

  • Amazon Redshift always creates views with varchar columns from tables with strings. You must cast string columns to varchar with an explicit length when adding dialects from other engines.

  • Granting data lake permissions to All views within a database will result in the grantee having permissions on all tables and views within the database.

  • You can't create views:

    • That references other views.

    • When the reference a table is a resource link.

    • When reference tables have IAM_ALLOWED_GROUP principal permissions.

    • When the reference table is in another account.

    • From external Hive metastores.