Athena

Athena support is currently limited to read-only access via Glue Catalog mirroring. Please contact us if you are interested in full read/write support.

Requirements

  1. AWS Account
  2. Warehouse configured with your Bucket

Overview

Tabular provides the ability to mirror warehouse databases and tables into Glue. This enables AWS Athena to read the Iceberg tables directly and Tabular will keep the tables in sync.

Current Limitations

  • This is a one-way replication, so mirrored tables should be considered read-only. Making changes to the tables directly from Glue or Athena will not update Tabular and may be overwritten by future changes.
  • Athena does not leverage Tabular’s permission system to access tables. It is recommended that you use IAM permissions directly to restrict access as needed.
  • Glue only has a single catalog per region, so mirroring multiple warehouses is not advised due to possible namespace conflict.

Configuration

Enabling Glue Mirroring is available on the warehouse Settings page.

Enable Glue Mirroring

  1. In the ‘Glue mirroring’ section, select ‘EDIT’
  2. Toggle ‘Enabled’
  3. Click on ‘Apply Changes’
button

Enable Glue mirroring for a warehouse

View Databases/Tables in Glue

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

Query your Iceberg tables in Athena

After verifying the tables are visible in Glue, navigate to AWS Athena console.

  1. Configure a storage location for Athena query results via Manage settings
  2. Use the Query Editor to run queries against any of the Iceberg tables in your Tabular warehouse.