Live reads with ogr_fdw

What it is

For cases where you want a live, read-only view of an AGOL layer rather than a materialized copy, agol_fdw pairs with the ogr_fdw extension to expose the layer as a Postgres foreign table. You query it like any other table; reads are served live from AGOL.

Why it matters

• Two modes, one database. Materialize authoritative copies or read AGOL live — pick per layer.
• No ETL job. Ad-hoc analysis against the latest AGOL state without a sync step.
• Read-only by construction. Foreign tables don't accept writes, so there's no risk of desync through this path.

See it

-- once an ogr_fdw foreign table is wired to an AGOL layer,
-- query it like any table — served live from ArcGIS Online:
SELECT status, count(*)
FROM agol_fdw_live.poles
GROUP BY status;

Related

← Back to home