query_iceberg
Query an Iceberg data lake table using Postgres foreign data wrapper. Filter, order, and limit results with optional WHERE, ORDER BY, and LIMIT clauses.
Instructions
SELECT from an Iceberg foreign table via Postgres FDW (e.g. 'iceberg.aud_analytics_lake')
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Full table name including schema (e.g. 'iceberg.aud_analytics_lake') | |
| where | No | Optional WHERE clause (uses parameterized query) | |
| order_by | No | Optional ORDER BY clause (column.direction format) | |
| limit | No |