AWS Glue

On this page:

Requirements

  • Tabular warehouse using an AWS S3 storage profile

Overview

Tabular enables you to mirror warehouse databases and tables into Glue. In turn this enables any system that integrates with the Glue catalog to read Tabular managed Iceberg tables.

Current Limitations

  • This is a one-way replication; mirrored tables should be considered read-only. Any changes you make to the tables directly from Glue do not update in Tabular, and may be overwritten by succeeding changes. by future changes.
  • Glue does not leverage Tabular’s permission system to access tables. We recommended you use IAM permissions directly to restrict access as needed.
  • Glue has only a single catalog per region, so mirroring multiple warehouses is not advised due to possible namespace conflict.
  • This is available only for warehouses using customer-owned and -managed S3 Storage Profiles. It is not available for any other warehouse, such as the auto-provisioned sandbox warehouse.

Configuration

You can enable Glue Mirroring from the warehouse Overview page.

To enable Glue mirroring

  1. From the warehouse Overview page, in the top navigation hover over Connections, and from the menu that displays click Compute. The Compute page displays.
  2. Under the Catalog Syncs section, click Amazon Glue.
  3. Follow the steps in the Glue Setup Wizard.
button

Enable Glue mirroring for a warehouse

View Databases/Tables in Glue

In the AWS Console in the region where your warehouse is located, navigate to Glue Databases and verify that the databases/tables in your warehouse are visible.

Query your Iceberg tables

After verifying the tables are visible in Glue, you can query them using engines such as Redshift.