Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.cognite.com/llms.txt

Use this file to discover all available pages before exploring further.

The PostgreSQL Gateway lets you access CDF data using standard PostgreSQL tools and queries. Gateway users represent credentials that can connect to CDF through the PostgreSQL protocol. You can create, list, update, and delete gateway users, each with their own access permissions.

​
What gateway users are

A gateway user is an identity that is authorized to connect to CDF via the PostgreSQL protocol. Each user has credentials (such as username and password) that clients use to establish a connection. The user’s permissions determine which CDF data they can query and what operations they can perform.

​
Use cases

  • SQL tools: Connect from tools like DBeaver, pgAdmin, or psql to query CDF data as if it were a PostgreSQL database.
  • BI integrations: Enable business intelligence tools that support PostgreSQL to connect directly to CDF.
  • Custom applications: Build applications that use standard PostgreSQL drivers to access CDF.
Gateway users are separate from CDF API keys and OIDC login. Manage them independently for PostgreSQL-specific access.

​
Managing gateway users

You create gateway users via the API and assign appropriate permissions. Each user can be configured with access to specific data sets, resource types, or other scopes. You can update credentials or revoke access by deleting the user when it is no longer needed.
Last modified on April 23, 2026