What gateway users are
A gateway user is an identity that is authorized to connect to CDF through the PostgreSQL protocol. Each user has credentials, such as a username and password, that clients use to establish a connection. The user’s permissions determine which CDF data they can access and what operations they can perform.Use cases
- Ingestion: Connect ETL tools that write to PostgreSQL, such as Azure Data Factory, and ingest data into CDF.
- SQL tools: Connect from tools like DBeaver, pgAdmin, or psql to verify ingested data with a simple filtered read. Don’t use these connections for business intelligence or aggregation-heavy queries. See Limitations.
- Custom applications: Build applications that use standard PostgreSQL drivers to ingest data into CDF.
Gateway users are separate from CDF API keys and OIDC login. Manage them independently for PostgreSQL-specific access.