Iceberg Foreign Table
Apache Iceberg is a table format designed for data lakes, providing a unified way to manage table storage and metadata at scale. Iceberg supports advanced features like partitioning, data updates, time travel, and snapshots. Its Catalog interface manages and discovers metadata across multiple tables, supporting consistent table operations across environments and engines. Multiple Catalog backends—such as Hive Metastore, REST, and AWS Glue—are available for metadata storage and retrieval.
Tacnode integrates with Iceberg REST Catalog using foreign tables, enabling accelerated queries along with efficient data import and export.
Install the Extension
Install the extension once; skip if already installed.
Create an Iceberg REST Catalog Foreign Server
endpoint
: The API endpoint of the Iceberg REST Catalogcatalog
: Root directory of the table metadata files
Create a User Mapping
Grant access to object storage for the local user account.
Import Foreign Tables
Import metadata for Delta-type tables from the Iceberg REST Catalog.
remote_schema_name
: Namespace in the Iceberg REST Catalogtable_name
: Table name in the Iceberg REST Catalogserver_name
: Previously defined foreign server