The PostgreSQL gateway is primarily intended for ingestion. You can run a simple filtered read in a SQL client to verify ingested data. Aggregations, joins, and
ORDER BY on fields the CDF API doesn’t support sorting on aren’t pushed down and can trigger a full table scan. Don’t connect business intelligence tools to the gateway. For BI or aggregation-heavy queries, use Transformations to materialize data, then query that result. Don’t query the materialized data through the PostgreSQL gateway. See Limitations and how the PostgreSQL gateway works.APIs in this group
- Postgres gateway users: Create and manage gateway user credentials.
- Postgres gateway tables: Manage tables that expose CDF data.