Skip to main content
Question

PostgreSQL Gateway 2.0


Hi Team, 

I am trying to Setup PostgreSQL Gateway 2.0 for loading data to CDF through Alteryx tool. But while following the steps provided on below link I am  facing below error. Is this something you can help ? 

https://docs.cognite.com/cdf/integration/guides/interfaces/postgres_gateway/

 

 

4 replies

  • Practitioner
  • 68 replies
  • February 6, 2025

Hi. In order to configure the postgres gateway you need the “postgresgateway:read” and “postgresgateway:write” ACLs. You should contact your administrator and have them grant you access to this through the Fusion UI.

 

See https://docs.cognite.com/cdf/access/guides/capabilities


Thanks, I will check this and get back to you. 


@Einar Omang  ​@Mithila Jayalath  After making changes as you suggested I am getting below error. 

{

    "error": {

        "code": 400,

        "message": "Failed to bind session: Nonce has expired or session has been revoked"

    }

}

 

What should I pass in the place of <SESSION NONCE>. Below is the Postman Body I am using. 

{
"items": [
{
"credentials": {
"nonce": "<SESSION NONCE>"
}
}
]
}


Mithila Jayalath
Seasoned Practitioner
Forum|alt.badge.img

@Rajendra Pasupuleti try using the nonce string that gets returned when you create a session. Please refer to the documentation here.


Reply


Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings