import os
from cognite.client.data_classes.postgres_gateway import UserWrite, SessionCredentials
from cognite.client.data_classes import ClientCredentials
session = client.iam.sessions.create(
    ClientCredentials(os.environ["IDP_CLIENT_ID"], os.environ["IDP_CLIENT_SECRET"]),
    session_type="CLIENT_CREDENTIALS"
)
user = UserWrite(credentials=SessionCredentials(nonce=session.nonce))
res = client.postgres_gateway.users.create(user)

{
  "items": [
    {
      "host": "fdw.<CLUSTER>.cogniteapp.com",
      "username": "<string>",
      "password": "<string>",
      "createdTime": 1730204346000,
      "lastUpdatedTime": 1730204346000,
      "sessionId": 4503599627370496
    }
  ]
}