AWS Glue Data Catalog now supports creating and managing SQL views that can be accessed from multiple analytics engines like Amazon Athena, Amazon Redshift, and Amazon EMR, simplifying data access control and reducing redundant view creation across engines.

<div>
<p>This article discusses AWS Glue Data Catalog's support for multi-engine views with AWS Analytics Engines. It allows customers to create SQL views in AWS Glue Data Catalog that can be queried from multiple SQL engines like Amazon Athena, Amazon Redshift, and Spark with Amazon EMR on EC2.</p>
<p>Specifically, the article covers:</p>
<ul>
<li>The ability to create a single view object that can be accessed across multiple SQL engines without consumers needing direct access to the underlying base tables.</li>
<li>The use of AWS Glue Data Catalog multi-engine views to control what parts of underlying data consumers can access using SQL dialects provided by SQL engines.</li>
<li>The ability to control access to views using the same AWS Lake Formation permissions for resources, columns, and tags used to grant access to other resources in the data lake.</li>
<li>The availability of this feature for preview in multiple AWS Regions, including Northern Virginia, Ohio, Oregon, Ireland, and Tokyo.</li>
</ul>
</div>


AWS Glue Data Catalog supports multi engine views with AWS Analytics Engines

Related articles